Working With Times in Excel
Microsoft Excel stores dates as sequential serial numbers for use in calculations. 1 January 1900 is serial number 1. 2 January 1900 is serial number 2, and so on. Thus, 1 January 2000 is serial number 36526 because it is 36,525 days after 1 January 1900. Logically, a time of day is a fraction of…