Export a timestamp as Unix milliseconds
Turn November 4, 2026 2:30:15 PM UTC into 1793802615000, to the nearest millisecond.
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 | *86400000 | Turns days into milliseconds: 86,400,000 in a day. | 1793802615000 |
| 4 | ROUND( … ,0) | Rounds to the nearest whole millisecond. | 1793802615000 |
Read it left to right. The time of day becomes part of a day, so it counts too.
=ROUND((A8-DATE(1970,1,1))*86400000,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 milliseconds 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, and check the system wants milliseconds, not seconds.
Microsoft's help: ROUND function
OTHER ROUTES YOU MIGHT LIKE

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 →
Create a timestamp filename label
November 4, 2026 2:30:15 PM → 20261104_143015
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →