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

In Excel: 2026-11-04T14:30:15.123-10:00 becomes 11/5/2026 12:30:15.123 AM.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1DATEVALUE( … )Reads the date from the first 10 characters.11/4/2026
2TIMEVALUE( … )Reads the hours, minutes and seconds and adds them.… 2:30:15 PM
3MID(A8,21,3)/86400000Adds the 3 digits after the dot as milliseconds.… 2:30:15.123 PM
4IF( … "+",1,-1)1 for a plus offset, -1 for a minus offset.-1
5( … )/1440The 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))/1440

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. 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.
  3. 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