Convert an offset timestamp to UTC
Turn the text 2026-11-04T14:30:15+05:30 into UTC: November 4, 2026 9:00:15 AM.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | DATEVALUE( … ) | Reads the first 10 characters as a date. | November 4, 2026 |
| 2 | TIMEVALUE( … ) | Adds the clock time after the T. | November 4, 2026 2:30:15 PM |
| 3 | IF( … ) | Gives 1 for a plus sign, -1 for minus. | 1 |
| 4 | ( … )/1440 | Turns the offset into part of a day, then takes it away. | November 4, 2026 9:00:15 AM |
A day has 1,440 minutes. A plus offset is ahead of UTC, so it comes off; a minus offset is added.
=DATEVALUE(LEFT(A8,10))+TIMEVALUE(MID(A8,12,8))-IF(MID(A8,20,1)="+",1,-1)*(MID(A8,21,2)*60+RIGHT(A8,2))/1440How 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 timestamps. Paste timestamps like 2026-11-04T14:30:15+05:30 into the green column of the Template tab. The UTC dates and times fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
The results are UTC, not your local time. Say UTC in the column title so nobody misreads them.
Microsoft's help: TIMEVALUE function
OTHER ROUTES YOU MIGHT LIKE

Convert millisecond timestamps to UTC
2026-11-04T14:30:15.123-10:00 → 11/5/2026 12:30:15.123 AM
Get the template →
Convert a local timestamp to UTC
11/4/2026 2:30:15 PM, offset 5.5 → 11/4/2026 9:00:15 AM UTC
Get the template →
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 →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →