Convert UTC to Local Time

  • Publié le 12 janv. 2026
  • 1 procès-verbal (procès-verbaux) lu(s)
Précédent Suivant

When working with reports in TAP Explore, TAP Affidavit Report , Podcast Explore, and Lineup Explore, dates and times are UTC-based.

To use your local timezone when preparing reports, follow the steps below.

Get Your Local Offset

Your offset is the difference between your local time and UTC. You’ll use your offset to calculate dates and times between UTC and your local timezone.

Examples: The offset for Montreal, Canada is UTC-5. The offset for Brisbane, Australia is UTC+10.

Your offset may change during daylight saving time (DST), so make sure to add 1 hour to your offset. Examples: In Montreal during DST, the offset is UTC-4. Brisbane does not observe DST, so its offset is always UTC+10.

These steps use World Time Buddy, but you can use any web page or app that calculates time zones.

  1. In your web browser, go to Time Converter and World Clock. The UTC timezone has already been entered for you. It appears with the home icon.

  2. In Place or timezone, add your location.

  3. The number next to your location is the offset from UTC. In this example, the offset is -5.

Convert UTC Timestamps to Local Time

With your local offset, you can use this spreadsheet formula to convert UTC to your local time:

UTC + (offset / 24)

Example: In Montreal, Canada with an offset of UTC-5, the formula is UTC + (-5/24).

You can use this formula in a report that you’ve exported to CSV or Microsoft Excel.

  1. Prepare your report in TAP Explore, TAP Affidavit Report , Podcast Explore, or Lineup Explore.

  2. Export the report to CSV or Microsoft Excel (xlsx) format. Voir Exportation des rapports de métrologie Triton

  3. Open the exported report in Excel or your preferred spreadsheet app.

  4. Insert a new column and name it Local TZ.

  5. In the first cell of that column, enter the formula =UTC + (OFFSET / 24), where UTC is the corresponding cell that contains the UTC timestamp, and OFFSET is your local offset.

  6. Give the cell a custom format to show the cell’s content as date and time. Example: In Excel, you can use the this custom format: yyyy-mm-dd hh:mm. The actual format you use depends on your speadsheet app and language.

  7. Copy this cell for the rest of the column.