> For the complete documentation index, see [llms.txt](https://docs.plumvoice.com/insight/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.plumvoice.com/insight/reporting/translating-unix-timestamps.md).

# 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.