Question posted 2013 · +4 upvotes
I was writing a routine to read from an Excel spreadsheet.
I have just discovered thro that MS Excel spreadsheet that
1 microsoft second = 0.00001157407407
1/1/1900 0:00:01.000 1.000011574
1/2/1900 0:00:02.000 2.000023148
Why?
Why not 0.00001, or some rounder number?
What is the significance of 0.00001157407407?
Binary value = 0.00000000000000001100001000101110
Accepted answer +19 upvotes
In Excel, each day is represented by 1.0, with a value of 1.0 being equal to January 1st, 1900 (ie: it’s effectively the days since 12/31/1899, plus one if you’re after Feb 1900).
This works out to each second being the number you posted, which is effectively 1 day / (24 * 60 * 60) or 1 / 86400 == 0.00001157407407.
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
— top 18%.