Combine a date, time and offset into UTC
Turn 11/4/2026, 2:30:15 PM and offset -10 into 11/5/2026 12:30:15 AM UTC.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | INT(A8) | The local date, with any time in it dropped. | 11/4/2026 |
| 2 | +MOD(B8,1) | Adds the local time, with any date in it dropped. | 11/4/2026 2:30:15 PM |
| 3 | -C8/24 | Takes away the offset hours. A day has 24 hours. | 11/5/2026 12:30:15 AM |
Excel stores a day as 1. Taking away a negative offset adds hours, sometimes moving to the next day.
=INT(A8)+MOD(B8,1)-C8/24How 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 local dates, times and their UTC offsets into the green columns 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
Use the offset that was right on that exact date. This formula doesn't know about daylight saving time.
Microsoft's help: INT function
OTHER ROUTES YOU MIGHT LIKE

Export a time like T14:30:15+05:30
2:30:15 PM, +05:30 → T14:30:15+05:30
Get the template →
Apply an hour and minute offset
11/4/2026 2:30:15 PM, -00 and 30 → 11/4/2026 2:00:15 PM
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 →