Convert a local timestamp to UTC
Turn 11/4/2026 2:30:15 PM at offset 5.5 into 9:00:15 AM UTC. Half-hour offsets work too.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The local date and time. | 11/4/2026 2:30:15 PM |
| 2 | -B8/24 | Takes away the offset hours. A day has 24 hours. | 11/4/2026 9:00:15 AM |
Excel stores a day as 1. A negative offset adds hours, sometimes moving to the next day.
=A8-B8/24How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own dates and times. Paste local dates with times and their UTC offsets into the green columns of the Template tab. The UTC times fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use the offset that was right on that exact date. This formula doesn't know about daylight saving time.
Microsoft's help: TIME function
OTHER ROUTES YOU MIGHT LIKE

Move a timestamp to a new UTC offset
11/4/2026 2:30:15 PM, 5.5 to -6 → 11/4/2026 3:00:15 AM
Get the template →
Read a signed hh:mm offset as minutes
-03:30 → -210 minutes
Get the template →
Convert an offset clock time to UTC
14:30:15+05:30 → 09:00:15 UTC clock
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →