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

    Converting Unix Time / Epoch Time to Real Time

    • Dark
      Light
    • PDF

    Article Summary

    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?