How to Convert Excel to Unix
To convert excel to unix, multiply the value by 1.
The Formula
Unix = Excel × 1
Key Fact
1 excel serial date = 1 unix
Tip: To convert unix back to excel, divide by 1.
Convert excel (Excel) to unix (Unix) with formulas, examples, and conversion tables.
To convert 1 excel to unix, we multiply by 1 because one excel serial date equals exactly 1 unix.
Since each excel serial date contains 1 unix, we multiply our value by this factor:
So 1 excel = -2209075200 unix.
To convert excel to unix, multiply the value by 1.
1 excel serial date = 1 unix
| Excel | Unix |
|---|---|
| 0 Excel | -2209161600 Unix |
| 86400 Excel | 5255798400 Unix |
| 604800 Excel | 5e+10 Unix |
| 1765116783 Excel | 1.53e+14 Unix |
| Unit | 1 Excel = |
|---|---|
| Excel Date to Unix Timestamp | -2209075200 Unix |
| Excel Serial Date to ISO 8601 | -2209075200 ISO |
| Excel Serial Date to Julian Day | 2415019.5 JD |
| Excel Serial Date to Modified Julian Day | 15019 MJD |