Understanding how Excel records and stores times

In column D, an important piece of information in this worksheet is the Time…recorded for the various sales that have been made. Perhaps some analysis is…going to be done based on which times of day…the greatest sales were recorded at.…So, when we make an entry of a time, it's similar to what we do with dates in Excel.…Excel actually stores a value.…The unit of measure in Excel for dates and times is 1 equals a day.…If I put in, for example, a time, 4:30, that actually represents a portion of the…day. Now it's about 4/24th.…

It's about a sixth of the day.…We're not thinking of that when we make data entries, but a real value is being…stored here, and it's a portion of the day.…We can quickly see what this value is - although we don't really need to do this…very often - by clicking the comma button. That's one fast way to do this.…That's 0.19 of the day, and just for the moment here, as I press Ctrl+Z to undo,…you could experiment with this a little bit…to get a sense of it yourself.…You could imagine that 6 AM is a quarter of the day.…