Apply an hour and minute offset
Turn 11/4/2026 2:30:15 PM with -00 and 30 minutes into 11/4/2026 2:00:15 PM.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The date and time in UTC. | 11/4/2026 2:30:15 PM |
| 2 | IF(LEFT(B8,1)="-",-1,1) | Gives -1 when the hour starts with a minus. | -1 |
| 3 | (ABS(VALUE(B8))*60+C8) | The whole offset in minutes, without its sign. | 30 |
| 4 | /1440 | Turns the minutes into days and adds them. | 11/4/2026 2:00:15 PM |
Excel stores a day as 1, and a day has 1440 minutes. The minus on the hour covers the minutes too, so -00 and 30 is minus 30 minutes.
=A8+IF(LEFT(B8,1)="-",-1,1)*(ABS(VALUE(B8))*60+C8)/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 dates and times. Paste UTC dates with times, offset hours like -05 and the minutes into the green columns of the Template tab. The local times fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Keep the hour as text, so -00 keeps its minus. Use the offset that was in force at that moment.
Microsoft's help: VALUE function
OTHER ROUTES YOU MIGHT LIKE

Combine a date, time and offset into UTC
11/4/2026 + 2:30:15 PM, offset -10 → 11/5/2026 12:30:15 AM UTC
Get the template →
Export a time like T14:30:15+05:30
2:30:15 PM, +05:30 → T14:30:15+05:30
Get the template →
Read milliseconds since 1960
Milliseconds since 1960 2109421815000 → November 4, 2026 2:30:15 PM
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →