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

 

Board footera

 

Powered by Boardhost. Create a Free Forum

Zapfware North University. Racing Tactical Software - Expedition.
Online courses