Track Log files exported from ForeFlight use Epoch Time for timestamps. Epoch Time is the number of seconds that have elapsed since January 1, 1970 (UTC).
CSV File Showing an Epoch Timestamp
To convert Epoch Time to a readable date and time in Excel, use one of the following formulas:
Convert Epoch Time to GMT (UTC)
To convert Epoch time to GMT, use the following formula:
=CELL/(60*60*24)+DATE(1970,1,1)- Replace
CELLwith the cell containing the Epoch Time. - Format the target cells as Date/Time to view the converted timestamp.
CSV File with a Column Added to Show Time Converted to GMT from Epoch Time
Convert Epoch Time to a Specific Time Zone
To adjust for a specific time zone, modify the formula to account for the offset from GMT in hours:
=B4/(60*60*24)+DATE(1970,1,1)-TIME(5,0,0)CSV File with a Column Added to Show Time Converted to CST from Epoch Time
Last Updated:
Was this article helpful?