Converting Unix Time / Epoch Time to Real Time
  • Dark
    Light
  • PDF

Converting Unix Time / Epoch Time to Real Time

  • Dark
    Light
  • PDF

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?