Understanding how Excel records and stores times


show more Understanding how Excel records and stores times provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010: Working with Dates and Times show less
please wait ...

Understanding how Excel records and stores times

In this worksheet in Column D, times have been recorded for the time of the sale, time of day. Times in Excel are based on the date system. The unit of measure between dates is 1, but how does time play out here? It's not so obvious. Times as with dates considered values. If we type in a time 5:00, for example, 5 AM, we actually have stored here a value, the same way the dates are values or times. 5 o'clock represents a certain portion of the day. It's 5/24ths.

What if it were 6 AM? We would type 6:00. That's one-fourth of a day. Rarely do we need to see what the value is, but if you happened to click the comma in the Home tab, this is one quick way to get there. You will see that's the actual value being stored, one quarter. Most of the time you are not thinking about this. It does explain how we can subtract times from one another and how we can add values to time entries. So rarely do we actually need to click this button to see what the value is.

Just remember that whe...

Understanding how Excel records and stores times
Video duration: 1m 33s 1h 20m Intermediate

Viewers:

Understanding how Excel records and stores times provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010: Working with Dates and Times

Subject:
Business
Software:
Excel
Author:
please wait ...