Convert an offset clock time to UTC
Turn the text 14:30:15+05:30 into the UTC clock time 09:00:15.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TIMEVALUE( … ) | Reads the first 8 characters as a clock time. | 14:30:15 |
| 2 | IF( … ) | Gives 1 for a plus sign, -1 for minus. | 1 |
| 3 | ( … )/1440 | Turns the offset into part of a day, then takes it away. | 09:00:15 |
| 4 | MOD( … ,1) | Wraps round midnight so the time stays within one day. | 09:00:15 |
A day has 1,440 minutes. A plus offset is ahead of UTC, so it comes off; a minus offset is added.
=MOD(TIMEVALUE(LEFT(A8,8))-IF(MID(A8,9,1)="+",1,-1)*(MID(A8,10,2)*60+RIGHT(A8,2))/1440,1)How 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 times. Paste clock times like 14:30:15+05:30 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
There is no date, so a time that crosses midnight doesn't say which day. If the day matters, use the full timestamp instead.
Microsoft's help: MOD function
OTHER ROUTES YOU MIGHT LIKE

Read a timestamp if its zone matches
2026-11-04 14:30:15 UTC, label UTC → November 4, 2026 2:30:15 PM
Get the template →
Convert an offset timestamp to UTC
2026-11-04T14:30:15+05:30 → November 4, 2026 9:00:15 AM
Get the template →
Convert millisecond timestamps to UTC
2026-11-04T14:30:15.123-10:00 → 11/5/2026 12:30:15.123 AM
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →