Hi,

I have a drone log data giving me utc in microseconds(1524726996200110). I need to convert this to date-time-microseconds. Please tell me how to do that? I have tried it in excel using (utc*1E-6)/60/60/24-DATE(1970,1,1). However this lets me to view the data using formatting (m/d/yyyy h:mm:ss) but not the remaining microseconds. Anyone have an idea how to get that?May be a silly question.

Thanks,

Sundara

More Sundara Bharathi Dhamotharan's questions See All
Similar questions and discussions