Convert millisecond timestamps to UTC
Turn 2026-11-04T14:30:15.123-10:00 into 11/5/2026 12:30:15.123 AM in UTC.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | DATEVALUE( … ) | Reads the date from the first 10 characters. | 11/4/2026 |
| 2 | TIMEVALUE( … ) | Reads the hours, minutes and seconds and adds them. | … 2:30:15 PM |
| 3 | MID(A8,21,3)/86400000 | Adds the 3 digits after the dot as milliseconds. | … 2:30:15.123 PM |
| 4 | IF( … "+",1,-1) | 1 for a plus offset, -1 for a minus offset. | -1 |
| 5 | ( … )/1440 | The offset in minutes, as part of a day. | 11/5/2026 12:30:15… |
Read it left to right. A plus offset is taken away and a minus offset is added, giving UTC.
=DATEVALUE(LEFT(A8,10))+TIMEVALUE(MID(A8,12,8))+MID(A8,21,3)/86400000-IF(MID(A8,24,1)="+",1,-1)*(MID(A8,25,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.123-10:00 into the green column 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
The results are in UTC, so say UTC in the column name. Keep the original text if you need every digit exactly.
Microsoft's help: TIMEVALUE function
OTHER ROUTES YOU MIGHT LIKE

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 →
Read a signed hh:mm offset as minutes
-03:30 → -210 minutes
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →