Converting Unix Time / Epoch Time to Real Time

Unix time or Epoch time is the number of seconds since January 1, 1970. Some exported reports from Insights report time in this format.

Excel doesn't contain built-in functions for working with Unix dates so they must be derived.
Excel allows you to add a number of days to a date by using the "+" operator. Let's make use of that.


First convert the number of seconds to number of days (by dividing by 60*60*24) and then add the result to the date "1/1/1970".


The formula will look like

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

The quotes around the date are required. If they are not present, Excel will treat 1/1/1970 as an expression.

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