Expedition Expedition Navigation Software

You are not logged in. Would you like to login or register?



7/11/2019 5:44 pm  #1


What's the DateTime format used in Expedition log files for UTC?

Hi there,

I am looking at the logfiles raw data and I see the UTC time being in a strange format such as this 43650.291669. Does anyone know what this format is? It does not look like a Unix timestamp or any DateTime format I could think of.

This would be useful to interpret the raw data using custom tools. Any help appreciated. Thanks!

 

7/11/2019 5:54 pm  #2


Re: What's the DateTime format used in Expedition log files for UTC?

It is UTC as a Microsoft DATE type, which is why Excel etc can handle it easily.

https://docs.microsoft.com/en-us/cpp/atl-mfc-shared/date-type?view=vs-2019

 

7/11/2019 9:47 pm  #3


Re: What's the DateTime format used in Expedition log files for UTC?

In Excel (Or Open Office) convert format to required date/time format.

The number is the number of days since 1900.  The decimal part if multiplied by 86400 (seconds on a day) then divided by 24 gives hours, then divide by 60 to get minutes, ….

gregs wrote:

Hi there,

I am looking at the logfiles raw data and I see the UTC time being in a strange format such as this 43650.291669. Does anyone know what this format is? It does not look like a Unix timestamp or any DateTime format I could think of.

This would be useful to interpret the raw data using custom tools. Any help appreciated. Thanks!

 

 

7/12/2019 5:44 am  #4


Re: What's the DateTime format used in Expedition log files for UTC?

Could be a .csv file?
Change to .xlsx
Sometimes you have to change the dot (.) into a comma (, )  or vice versa
Then change cell format to a preferred time or date format

 

3/01/2023 11:56 am  #5


Re: What's the DateTime format used in Expedition log files for UTC?

I can't seem to figure out how to convert the UTC Date Format in the log file to a UTC date & time format.  Has anyone found a simple way to convert within Excel log file or discovered a conversion formula I can apply to the log file UTC values?  Any help would be appreciated!
 

 

3/01/2023 12:42 pm  #6


Re: What's the DateTime format used in Expedition log files for UTC?

It is already in the type native to Excel. You don't have to do any conversion.

This is part of the reason the DATE type was chosen.

If you want to display as a string, select the formatting for the column in Excel.

Last edited by Nick (3/01/2023 5:00 pm)

 

3/01/2023 2:49 pm  #7


Re: What's the DateTime format used in Expedition log files for UTC?

Got it - thanks Nick!

 

Board footera

 

Powered by Boardhost. Create a Free Forum


Interested in advertising here? Over a thousand active navigators and Expedition users visit this forum. Click here to contact the administrator.