Does Excel have a time zone conversion function?

No — Excel has no built-in function to convert between time zones. People add or subtract hours by hand, which is wrong for part of the year because it ignores daylight saving. Tellsheet's Timezone Converter shifts each date/time with DST handled automatically.

Why does adding hours break twice a year?

A fixed offset like −5 hours for New York is only correct in winter; in summer New York is −4 (EDT). Subtracting a constant is wrong for the months on the other side of the daylight-saving change. The Timezone Converter uses the real rules for each zone, so it's right year-round.

Is the result still a real Excel date?

Yes. Only genuine date/time cells are converted, and the output stays a real Excel date you can sort, filter, and compute on — it isn't turned into text.

Home › Excel Guides › Convert Time Zones in Excel

How to Convert Time Zones in Excel (Daylight-Saving Aware)

Excel has no time zone function, so people subtract a fixed number of hours — and get it wrong for half the year, because daylight saving moves the offset. Here's why, and the one-click way that gets it right.

Last updated: August 2026

UTC		New York
2026-01-15 12:00	→	2026-01-15 07:00 (EST, −5)
2026-07-15 12:00	→	2026-07-15 08:00 (EDT, −4)

Why adding hours breaks

The usual trick is a formula like =A2-5/24 to turn UTC into New York time. It's only right in winter: when daylight saving starts, New York shifts to −4 (EDT), so every value between March and November is an hour out. Half-hour zones such as India (+5:30) don't fit a whole-hour offset at all, and the fix breaks again at the next clock change.

The 1-click way — Tellsheet's Timezone Converter

Select the column of date/times and run Timezone Converter. Pick a From and a To zone — full IANA names like UTC and America/New_York — and it shifts each value with daylight saving applied automatically, using the JavaScript runtime's built-in IANA timezone database, so nothing is fetched and it works fully offline. Only real date/time cells are converted, and the result stays a real Excel date you can sort and compute on. Pairs with Convert Text to Date and Natural Sort.

Frequently asked questions

Does Excel have a timezone function?

No — there's no built-in one. Adding hours by hand ignores daylight saving; the Timezone Converter handles it for you.

Why is subtracting a fixed offset wrong?

New York is −5 in winter but −4 in summer, so a constant is only right for part of the year. The converter uses each zone's real rules.

What about half-hour zones like India?

They're handled — the IANA database knows India is +5:30, so no rounding to whole hours.

Does it need the internet?

No — it uses the runtime's built-in timezone data on your computer; nothing is fetched or uploaded.

Related Excel guides

Shift time zones in one click

Timezone Converter moves a column of date/times between zones with daylight saving handled — offline, and the result stays a real Excel date.

Get Tellsheet free See pricing