What is the time format used in an exported .CSV Track Log file?

The time used by ForeFlight in Track Logs is Epoch Time, which is part of a software time keeping system. The Excel formula to convert the epoch time to actual date/time is:

     =(CELL/1000)/(60*60*24)+"1/1/1970"

If you enter a column for time correction into your spreadsheet, be sure to set the cells to a date/time format.   

Image 1.  Imported CSV file showing an uncorrected Epoch timestamp.

 

Image 2.  CSV File with column added showing Epoch time correction.

 Time displayed will be in GMT time.  If you want to convert to a specific time zone, you can adjust the formula used to look as follows:

     =((CELL/1000)/(60*60*24)+"1/1/1970")-TIME(HOURS TO ADJUST,0,0)

Here is a sample of an actual formula used with a time subtraction of 5 hours:

     =((B4/1000)/(60*60*24)+"1/1/1970")-TIME(5,0,0)