Converting Unix Time / Epoch Time to Real Time
- Print
- DarkLight
- PDF
Converting Unix Time / Epoch Time to Real Time
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
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 606024) and then add the result to the date "1/1/1970".
The formula will look like:
=CELL/(606024)+"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?