---
title: "Convert UTC to Local Time"
slug: "convert-utc-to-local-time"
updated: 2026-01-12T16:41:05Z
published: 2026-01-12T16:41:05Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.tritondigital.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Convert UTC to Local Time

When working with reports in [TAP Explore](/user/docs/tap-reports-tap-explore), [TAP Affidavit Report](/user/docs/tap-affidavit-report) , [Podcast Explore](/user/docs/podcast-explore), and [Lineup Explore](/user/docs/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](https://www.worldtimebuddy.com/?pl=1&lid=100&h=100&hf=1), but you can use any web page or app that calculates time zones.

![](https://cdn.document360.io/7124b381-0a94-401a-abbd-9df9c4ea5dff/Images/Documentation/convert-utc.png)

1. In your web browser, go to [Time Converter and World Clock](https://www.worldtimebuddy.com/?pl=1&lid=100&h=100&hf=1). 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.

![](https://cdn.document360.io/7124b381-0a94-401a-abbd-9df9c4ea5dff/Images/Documentation/convert-speadsheet.png)

1. Prepare your report in [TAP Explore](/user/docs/tap-reports-tap-explore), [TAP Affidavit Report](/user/docs/tap-affidavit-report) , [Podcast Explore](/user/docs/podcast-explore), or [Lineup Explore](/user/docs/lineup-explore).
2. Export the report to CSV or Microsoft Excel (xlsx) format. See [Exporting Triton Metrics Reports](/user/docs/exporting-triton-metrics-reports).
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.