Follow

kontextURL CSV export - Date Format

When you are exporting the kontextURL click data incsv format, the timestamp column is reported in the "Epoch" or "Unix" time format. The number represents the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC), Thursday, 1 January 1970.

To convert the number to your local time format, create a new column with the following format in each of the cells.

 

 Cell E1 Formula  would be     '=(((D1/60)/60)/24)+DATE(1970,1,1)+(-5/24)'

Note:  that you need to insert your proper timezone offset in the last bracket.  E.g. Eastern Time is -5.

You may also have to format the column as a "Time" type with the data & time displaying 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk