Export UTC timestamps as Unix seconds
Turn November 4, 2026 2:30:15 PM UTC into 1793802615, rounded to the nearest second.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The UTC date and time. | November 4, 2026 2:30… |
| 2 | -DATE(1970,1,1) | Counts the days since January 1, 1970. | 20761.6043 |
| 3 | *86400 | Turns days into seconds: 86,400 in a day. | 1793802615 |
| 4 | ROUND( … ,0) | Rounds to the nearest whole second. | 1793802615 |
Read it left to right. The time of day becomes part of a day, so it counts too.
=ROUND((A8-DATE(1970,1,1))*86400,0)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 times. Paste real dates with times into the green column of the Template tab. The Unix seconds fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use times that are already in UTC. Excel doesn't change local time to UTC for you.
Microsoft's help: ROUND function
OTHER ROUTES YOU MIGHT LIKE

Export a timestamp as Unix milliseconds
November 4, 2026 2:30:15 PM → Unix milliseconds 1793802615000
Get the template →
Write a full appointment date and time
11/4/2026 2:30 PM → November 4, 2026 at 2:30 PM
Get the template →
Write a timestamp caption that says UTC
11/4/2026 2:30 PM → Nov 4, 2026 2:30 PM UTC
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →