Isn't this just common sense? Everyone understands how to read dates and tell time. But, do you know how Excel stores those values? The number 1 as a date value is January 1, 1900 and 0.00 is midnight. Learn exactly how Excel stores your data, so you can work with it more accurately.
Text00:17 In this segment, you'll get a comprehensive understanding of how Excel interprets Dates. Did you know that the number 1 shown as an Excel date is 1/1/1900? The default continues as: 2=1/2/1900, 3=1/3/1900, etc.
02:36 In this segment, you'll get a comprehensive understanding regarding how Excel interprets Times. Did you know that time is measured in fractions of one (1)? 0.5 is 12 noon and 0.75 is 6pm. Learn how Excel Dates & Times work together, so you can start building more powerful formulas!
03:39 Here, we look at how we can open the Format Cells dialog window with the shortcut Ctrl+1 and create a custom Date & Time format. While in the Format Cells dialog window and in the "Number" tab, select the "Custom" label under Category. In this section, Excel allows you to manually type your own formats here (Y=Year, M=Month, D=Day, H=Hour, M=Minute, S=Second). Try it out!
VideoGIF
DateTime-Outlines-1.xlsx