convertimate Unix timestamp

Unix timestamp (seconds) to Excel serial date

Type a value in s to get it in Excel instantly.

39857.980208Excel

That moment falls on a Friday, day 44 of 2009 (UTC).

Convert the other way: Excel to s

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 s to Excel

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: 1234567890 s = 39857.980208 Excel.

Every unit

That moment in every format

Tables

s to Excel conversion table

s to Excel conversion table
sExcel
946684800 s36526 Excel
1000000000 s37143.074074 Excel
1100000000 s38300.481481 Excel
1200000000 s39457.888889 Excel
1300000000 s40615.296296 Excel
1400000000 s41772.703704 Excel
1500000000 s42930.111111 Excel
1600000000 s44087.518519 Excel
1700000000 s45244.925926 Excel
1800000000 s46402.333333 Excel
1900000000 s47559.740741 Excel
2000000000 s48717.148148 Excel
2147483647 s50424.134803 Excel
Excel to s conversion table
Excel to s conversion table
Excels
36526 Excel946684800 s
37143 Excel999993600 s
38300 Excel1099958400 s
39458 Excel1200009600 s
40615 Excel1299974400 s
41773 Excel1400025600 s
42930 Excel1499990400 s
44088 Excel1600041600 s
45245 Excel1700006400 s
46402 Excel1799971200 s
47560 Excel1900022400 s
48717 Excel1999987200 s
50424 Excel2147472000 s

Quick answers

Quick answers

How many Excel is 1 s?
1 s is 25569.000012 Excel.
How many Excel is 10 s?
10 s is 25569.000116 Excel.
How many Excel is 1234567890 s?
1234567890 s is 39857.980208 Excel.

The units

About these units

Unix timestamp (seconds) (s)

Seconds since 1970-01-01 00:00:00 UTC: Unix, Linux, PHP, Python.

Excel serial date (Excel)

Days since 30 December 1899, as Excel and Google Sheets store dates.

Learn more about moment units

Keep going

Related conversions