Read a timestamp if its zone matches
Turn 2026-11-04 14:30:15 UTC into a real date and time, but only when it ends in UTC.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | RIGHT( … )=" "&B8 | Checks the text ends in a space and the label. | TRUE |
| 2 | DATEVALUE( … ) | Reads the first 10 characters as a date. | November 4, 2026 |
| 3 | TIMEVALUE( … ) | Adds the clock time after the space. | November 4, 2026 2:30:15 PM |
| 4 | "Review zone" | The message when the label doesn't match. | Not used for row 8 |
| 5 | IF( … ) | Shows the date and time, or else the message. | November 4, 2026 2:30:15 PM |
The label is only checked, not converted. A UTC timestamp stays in UTC.
=IF(RIGHT(A8,LEN(B8)+1)=" "&B8,DATEVALUE(LEFT(A8,10))+TIMEVALUE(MID(A8,12,8)),"Review zone")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 timestamps. Paste timestamps like 2026-11-04 14:30:15 UTC and the label you expect, like UTC, into the Template tab's green columns. The dates and times fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Check every Review zone row. Those times are in a different zone, so don't mix them in.
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

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 →
Convert a local timestamp to UTC
11/4/2026 2:30:15 PM, offset 5.5 → 11/4/2026 9:00:15 AM UTC
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →