Translating Unix timestamps

By default, all start and end times are recorded as Unix timestamps. This is a universal standard that accommodates all time zones. If you'd like to translate Unix timestamps into a more readable format, here's how:

  1. Open your report in Excel

  2. Create a new column for your readable date, put in this formula: =(((A1/60)/60-5)/24)+DATE(1970,1,1) where A1 is the column with the Unix timestamp, and -4 is the offset for GMT. For example, EST is -5 hours off from GMT, so this formula would provide the date in EST timezone. For GMT timezone, the formula would be

    =(((A1/60)/60)/24)+DATE(1970,1,1)

    For PST, the formula would be

    =(((A1/60)/60-8)/24)+DATE(1970,1,1)
  3. Once you hit enter, you will notice a numeric value. Make sure you format that cell as a “Date” and you may pick which date format you prefer.