Miscellaneous lessons from the Expert Skills course. - 03-07 Excel Date and Time - Everything you need to know.

When you see a date in an Excel cell, the cell really contains a number that has been formatted as a date. This underlying numeric value of all Excel date and time information is often referred to as a date serial number, a date-time serial number or a date-time code. This lesson will teach you all you need to know to work with Excel's numeric storage of date and time data. 0:00 Introduction. 0:46 How Excel stores dates (date serial numbers sometimes called Excel date-time code). 1:15 In Excel every time is a date, and every date is a time. 3:09 Demonstration of how numbers are used to represent dates and times in Excel. 4:50 Format numbers to display as date/time in the format dd/mm/yyyy hh:mm 6:40 Link to next lesson, course session playlist and to download sample file set. 8:15 Prove that the numbers 1-5 represent midnight on 1st Jan 1900 to 5th Jan 1900. 8.27 Prove that the number 2.5 represents midday on 2nd Jan 1900. 9:20 Prove that 3.75 represents 18:00 on 3rd January 1900. 9:46 Use date mathematics to compute the number of days in the 20th Century. 11:03 Link to next lesson, course session playlist and to download sample file set.