Excel serial date to Unix timestamp (seconds)
Type a value in Excel to get it in s instantly.
1234569600s
That moment falls on a Saturday, day 45 of 2009 (UTC).
Convert the other way: s to Excel
What it means
Where is that on the timeline?
All dates are UTC. Unix time and these counts ignore leap seconds; Excel serials follow the 1900 date system and start at 1 March 1900.
The math
How to convert Excel to s
date = 1970-01-01 00:00:00 UTC + timestamp seconds. Excel serial = Unix ÷ 86,400 + 25,569; Julian Date = Unix ÷ 86,400 + 2,440,587.5.
Example: 39858 Excel = 1234569600 s.
Every unit
That moment in every format
Tables
Excel to s conversion table
| Excel | s |
|---|---|
| 36526 Excel | 946684800 s |
| 37143 Excel | 999993600 s |
| 38300 Excel | 1099958400 s |
| 39458 Excel | 1200009600 s |
| 40615 Excel | 1299974400 s |
| 41773 Excel | 1400025600 s |
| 42930 Excel | 1499990400 s |
| 44088 Excel | 1600041600 s |
| 45245 Excel | 1700006400 s |
| 46402 Excel | 1799971200 s |
| 47560 Excel | 1900022400 s |
| 48717 Excel | 1999987200 s |
| 50424 Excel | 2147472000 s |
s to Excel conversion table
| s | Excel |
|---|---|
| 946684800 s | 36526 Excel |
| 1000000000 s | 37143.074074 Excel |
| 1100000000 s | 38300.481481 Excel |
| 1200000000 s | 39457.888889 Excel |
| 1300000000 s | 40615.296296 Excel |
| 1400000000 s | 41772.703704 Excel |
| 1500000000 s | 42930.111111 Excel |
| 1600000000 s | 44087.518519 Excel |
| 1700000000 s | 45244.925926 Excel |
| 1800000000 s | 46402.333333 Excel |
| 1900000000 s | 47559.740741 Excel |
| 2000000000 s | 48717.148148 Excel |
| 2147483647 s | 50424.134803 Excel |
Quick answers
Quick answers
- How many s is 39858 Excel?
- 39858 Excel is 1234569600 s.
The units
About these units
Excel serial date (Excel)
Days since 30 December 1899, as Excel and Google Sheets store dates.
Unix timestamp (seconds) (s)
Seconds since 1970-01-01 00:00:00 UTC: Unix, Linux, PHP, Python.
Keep going