Read long Unix codes, even before 1970
Turn -1361957384876544 microseconds into 11/4/1926 2:30:15.123 PM UTC.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | IF(LEFT(A8,1)="-", … ) | Drops a leading minus. LET calls it s. | "1361957384876544" |
| 2 | IF(LEN(s)>n, … ,"0") | All but the last n digits, or 0. LET calls it w. | "1361957384" |
| 3 | RIGHT(REPT("0",n)&s,n) | The last n digits, the part of a second. LET calls it f. | "876544" |
| 4 | DATE(1970,1,1)+ … /86400 | Counts from January 1, 1970, back for a minus. | 11/4/1926 2:30:15.123 PM |
| 5 | LET( … ) | Names each step so the formula reads in order. | 11/4/1926 2:30:15.123 PM |
LET calls the unit in B8 n: 6 for microseconds, 9 for nanoseconds. The cell shows 3 of the digits.
=LET(s,IF(LEFT(A8,1)="-",MID(A8,2,99),A8),n,B8,w,IF(LEN(s)>n,LEFT(s,LEN(s)-n),"0"),f,RIGHT(REPT("0",n)&s,n),DATE(1970,1,1)+IF(LEFT(A8,1)="-",-1,1)*(VALUE(w)+VALUE(f)/10^n)/86400)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 codes. Paste codes like -1361957384876544 and their unit, 6 or 9, into the green columns of the Template tab. 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
Paste the codes as text. Typed as a number, Excel turns the last digits into zeros.
Microsoft's help: VALUE function
OTHER ROUTES YOU MIGHT LIKE

Combine seconds and nanos into UTC
1793802615 s, 500000000 ns → 11/4/2026 14:30:15.500
Get the template →
Combine seconds and nanos as days
178215 s, 500000000 ns → 2.062679 days
Get the template →
Join date and time codes, skip zeros
20261104 + 143015 → 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 →