How do I convert time zones in Excel?

Use a simple offset formula. If cell A1 contains a time in UTC and you want EST (UTC-5), the formula is: =A1-TIME(5,0,0). For EST to PST (subtract 3 hours): =A1-TIME(3,0,0). For EST to GMT (add 5 hours): =A1+TIME(5,0,0). Make sure your cells are formatted as Time or Date/Time, not General.

Does Excel handle daylight saving time automatically?

No. Excel's TIME() offset approach uses fixed hour differences and does not account for DST transitions. If your data spans DST change dates, you need to add conditional logic (IF statements checking the date against DST switch dates) or use a Power Query/VBA approach. For quick conversions, a dedicated timezone tool that auto-detects DST is faster.

How do I convert time zones in Google Sheets?

Google Sheets does not have a built-in timezone conversion function. The simplest approach is the same offset formula: =A1+TIME(hours,0,0) or =A1-TIME(hours,0,0). For a DST-aware solution, you can use Apps Script with Utilities.formatDate() which accepts IANA timezone names like 'America/New_York' and handles DST automatically.

How do I convert UTC to EST in Excel?

If A1 contains a UTC datetime, use =A1-TIME(5,0,0) for EST (standard time) or =A1-TIME(4,0,0) for EDT (daylight saving time). To handle both automatically, use: =A1-TIME(IF(AND(A1>=DST_START,A1<DST_END),4,5),0,0) where DST_START and DST_END are the transition dates for that year.

Is there a simpler alternative to Excel for timezone conversion?

Yes. If you need to convert a few times (not a column of thousands), a browser-based timezone converter is faster than building formulas. Enter a time, pick two zones, get the answer instantly. It handles DST automatically and works on any device. No formula debugging needed.

Can Power Query handle timezone conversions?

Power Query can add or subtract fixed hour offsets using #duration(0, hours, 0, 0). But like standard Excel formulas, Power Query does not natively handle DST. For DST-aware conversions in Power Query, you would need a custom function that checks dates against a DST transition table. It works, but it is complex to set up.

How to Convert Time Zones in Excel and Google Sheets (Formulas + Free Alternative)

Q: Is there a simpler alternative to Excel for timezone conversion?

Yes. If you need to convert a few times (not a column of thousands), a browser-based timezone converter is faster than building formulas. Enter a time, pick two zones, get the answer instantly. It handles DST automatically and works on any device. No formula debugging needed.

Q: Can Power Query handle timezone conversions?

Power Query can add or subtract fixed hour offsets using #duration(0, hours, 0, 0). But like standard Excel formulas, Power Query does not natively handle DST. For DST-aware conversions in Power Query, you would need a custom function that checks dates against a DST transition table. It works, but it is complex to set up.

Last updated: April 202610 min readCalculator Tools

Excel can convert time zones, but it does not do it well. There is no built-in timezone function. You are stuck writing offset formulas that break during daylight saving transitions. Here is how to make it work anyway, when to use Google Sheets instead, and when to skip the spreadsheet entirely.

Need a quick timezone conversion without formula gymnastics?

Open Free Timezone Converter

Method 1: Excel — Simple Offset Formula

The most common approach. It works for fixed-offset conversions where DST does not matter (or where all your data falls within the same DST period).

The formula

If cell A1 contains a datetime in one timezone, and you want to convert it to another:

=A1 + TIME(hours, 0, 0)    ‹ add hours to go east
=A1 - TIME(hours, 0, 0)    ‹ subtract hours to go west

Common conversions

Conversion	Formula	Hours
UTC to EST	`=A1-TIME(5,0,0)`	-5
UTC to PST	`=A1-TIME(8,0,0)`	-8
UTC to CET (Europe)	`=A1+TIME(1,0,0)`	+1
UTC to IST (India)	`=A1+TIME(5,30,0)`	+5:30
UTC to JST (Japan)	`=A1+TIME(9,0,0)`	+9
EST to PST	`=A1-TIME(3,0,0)`	-3
EST to GMT	`=A1+TIME(5,0,0)`	+5
PST to EST	`=A1+TIME(3,0,0)`	+3
CST to EST	`=A1+TIME(1,0,0)`	+1

Important: Format the result cell as "Time" or "Custom: mm/dd/yyyy hh:mm AM/PM." If Excel shows a decimal like 0.375 instead of 9:00 AM, that is a formatting issue, not a formula problem.

The DST problem

This formula uses a fixed offset. It does not know when daylight saving starts or ends. If your dataset contains timestamps from both winter (EST, UTC-5) and summer (EDT, UTC-4), a single -TIME(5,0,0) formula will be off by 1 hour for every summer timestamp.

For datasets that span DST transitions, you need the conditional approach below.

Method 2: Excel — DST-Aware Formula

This handles the US daylight saving transition automatically. It checks whether the date falls within the DST window and adjusts the offset.

=A1 - TIME(
  IF(AND(
    A1 >= DATE(YEAR(A1),3,1) + (15-WEEKDAY(DATE(YEAR(A1),3,1),3))*1,
    A1 < DATE(YEAR(A1),11,1) + (8-WEEKDAY(DATE(YEAR(A1),11,1),3))*1
  ), 4, 5),
0, 0)

This converts UTC to Eastern time with DST awareness. The formula calculates the second Sunday in March (spring forward) and first Sunday in November (fall back) for whatever year is in your data. During DST months, it subtracts 4 (EDT). During standard months, it subtracts 5 (EST).

Honestly? This formula is ugly, hard to debug, and easy to break. If you are staring at it thinking "there has to be a better way," you are right. For one-off conversions, a browser-based converter takes 3 seconds and handles DST automatically. For bulk spreadsheet data, read the Power Query section below.

Method 3: Google Sheets

Google Sheets has the same limitation as Excel: no built-in timezone conversion function. The offset formula works identically:

=A1 + TIME(5, 0, 0)    // EST to GMT
=A1 - TIME(3, 0, 0)    // EST to PST

But Google Sheets has one advantage that Excel does not: Apps Script.

Google Sheets Apps Script (DST-aware)

Go to Extensions > Apps Script, paste this function, and save:

function CONVERTTZ(datetime, fromTZ, toTZ) {
  var date = new Date(datetime);
  var fromStr = Utilities.formatDate(date, fromTZ, "yyyy-MM-dd'T'HH:mm:ss");
  var toDate = new Date(fromStr);
  return Utilities.formatDate(toDate, toTZ, "yyyy-MM-dd HH:mm:ss");
}

Now you can use it in any cell:

=CONVERTTZ(A1, "America/New_York", "Europe/London")
=CONVERTTZ(A1, "America/Los_Angeles", "Asia/Tokyo")
=CONVERTTZ(A1, "UTC", "America/Chicago")

This uses IANA timezone names, which means it handles DST automatically. "America/New_York" knows when to apply EST vs EDT. "Europe/London" knows when to apply GMT vs BST. No manual date checking needed.

The downside: Apps Script custom functions are slower than native formulas. On a sheet with 10,000 rows, you will notice the delay. For small datasets (under 1,000 rows), it works fine.

Method 4: Power Query (Excel)

If you are processing large datasets in Excel (thousands of timestamps from a database export, API logs, or CRM data), Power Query is the right approach.

Load your data into Power Query (Data tab > From Table/Range)
Select the datetime column
Add Custom Column with this formula:
```
[YourDateColumn] + #duration(0, -5, 0, 0)
```
This subtracts 5 hours (UTC to EST). Change the -5 to whatever offset you need.
Close & Load back to the worksheet

Power Query handles large datasets much faster than cell formulas. But like the basic formula approach, it uses fixed offsets. For DST-aware bulk conversions in Power Query, you would need a DST lookup table, which adds complexity.

When to Skip the Spreadsheet Entirely

Be honest about what you actually need. If the answer is one of these, a spreadsheet formula is overkill:

"What time is 3 PM EST in London?" — That is a 5-second lookup, not a formula project. Use a timezone converter.
"When should I schedule this meeting for 3 time zones?" — Our meeting scheduling guide has overlap tables ready to go.
"What is the time difference between EST and PST?" — It is always 3 hours. We break it down fully in our EST to PST guide.
"I need to convert 20 timestamps from a report" — Paste them into a quick converter. Faster than building and testing a formula.

Spreadsheet formulas make sense when you have a column of hundreds or thousands of timestamps that need conversion as part of a larger data workflow. For everything else, a dedicated tool saves you time and debugging headaches.

Common Mistakes (and How to Avoid Them)

Mistake 1: Cell not formatted as datetime

You write =A1+TIME(5,0,0) and get 0.583333 instead of 2:00 PM. Fix: right-click the cell, Format Cells, choose a Time or Date format.

Mistake 2: Forgetting that dates can roll over

If A1 is 11:00 PM EST and you add 5 hours for GMT, the result is 4:00 AM the next day. If your cell is formatted as Time only (no date), it will show 4:00 AM but you will not see that the date changed. Use a DateTime format that shows both date and time.

Mistake 3: Half-hour offsets

India (IST) is UTC+5:30. Iran is UTC+3:30. Nepal is UTC+5:45. The formula is =A1+TIME(5,30,0) for IST. People forget the minutes parameter and use TIME(5.5,0,0), which does not work as expected.

Mistake 4: Hardcoding the offset for data that spans DST

Your CRM export has timestamps from January through June. A fixed -TIME(5,0,0) formula (UTC to EST) is correct for January through early March but wrong for March through June (should be -4 for EDT). Every summer timestamp will be off by exactly 1 hour. You will not notice until someone complains.

Quick Reference: UTC Offsets for Common Zones

Zone	Standard	Daylight	Cities
EST / EDT	UTC-5	UTC-4	New York, Miami, Toronto
CST / CDT	UTC-6	UTC-5	Chicago, Houston, Mexico City
MST / MDT	UTC-7	UTC-6	Denver, Phoenix (no DST)
PST / PDT	UTC-8	UTC-7	Los Angeles, Seattle, Vancouver
GMT / BST	UTC+0	UTC+1	London, Dublin, Lisbon
CET / CEST	UTC+1	UTC+2	Paris, Berlin, Madrid
IST	UTC+5:30	No DST	Mumbai, Delhi, Bangalore
JST	UTC+9	No DST	Tokyo, Seoul, Osaka
AEST / AEDT	UTC+10	UTC+11	Sydney, Melbourne

For a deeper dive into specific zone pairs, see our EST to GMT guide (including the DST trap weeks when the difference shifts) and our EST to PST guide.

Skip the formulas. Convert any time between any zones in 3 seconds.

Open Timezone Converter