Read a signed hh:mm offset as minutes
Turn the offset text -03:30 into a number of minutes: -210.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | IF( … ) | Gives -1 for a minus sign, 1 for plus. | -1 |
| 2 | MID( … )*60 | Turns the two hour digits into minutes. | 180 |
| 3 | RIGHT( … ) | Adds the last two digits, the minutes. | -210 |
Parts 2 and 3 make 210 minutes. The * multiplies that by part 1, so -03:30 gives -210.
=IF(LEFT(A8,1)="-",-1,1)*(MID(A8,2,2)*60+RIGHT(A8,2))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 offsets. Paste offsets like -03:30 into the green column of the Template tab. The minutes fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
It doesn't check for real time zones, so +25:00 still gives 1500. Look over odd offsets.
Microsoft's help: LEFT function
OTHER ROUTES YOU MIGHT LIKE

Convert an offset clock time to UTC
14:30:15+05:30 → 09:00:15 UTC clock
Get the template →
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 →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →