Export a timestamp with no time zone
Turn November 4, 2026 2:30:15 PM into the text 2026-11-04T14:30:15 for an import.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The real date and time. | November 4, 2026 2:30:15 PM |
| 2 | "yyyy-mm-dd | Writes the date as year, month, day. | "2026-11-04" |
| 3 | ""T"" | Adds a capital T between date and time. | "2026-11-04T" |
| 4 | hh:mm:ss" | Adds the time: hours 00 to 23, minutes, seconds. | "2026-11-04T14:30:15" |
| 5 | TEXT( … ) | Writes the date and time in that pattern as text. | "2026-11-04T14:30:15" |
Parts 2 to 4 are one pattern. The doubled quotes keep T as a plain letter.
=TEXT(A8,"yyyy-mm-dd""T""hh:mm:ss")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 dates and times. Paste real dates and times into the green column of the Template tab. The timestamp text fills in by itself.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
The text has no time zone. Add Z only if the times are already UTC; it doesn't convert them.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

Export a UTC timestamp with a Z suffix
November 4, 2026 2:30:15 PM → 2026-11-04T14:30:15Z
Get the template →
Export a timestamp with milliseconds
11/4/2026 2:30:15.123 PM → 2026-11-04T14:30:15.123
Get the template →
Export a timestamp with a known offset
11/4/2026 2:30:15 PM, -05:00 → 2026-11-04T14:30:15-05:00
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →