AnsweredAssumed Answered

Event time in CSV

Question asked by Brendan Reid on Mar 23, 2017
Latest reply on Mar 23, 2017 by Brendan Reid

Hi there.

Looking for a way to convert the CSV exported Event Time value of 1490232221 back into 2017-03-22T18:23:41 or equivalent in Excel.

 

Note:
For Excel 2016, use the following:

=TEXT(A1/(60*60*24)+DATE(1970,1,1),"yyyy/mm/dd hh:mm:ss")

Outcomes