Microsoft Office Tutorials and References
In Depth Information
Perform
TIME CALCULATIONS
Using Excel formulas and functions, you can perform
calculations with dates and times. You can find, for
example, the number of hours worked between two
times or the number of days between two dates. Date
and time functions convert every date and time into a
serial value that can be added and subtracted and
then converted back into a recognizable date or time.
Excel calculates a date’s serial value as the number
of days after January 1, 1900, so each date can be
represented by a whole number. Excel calculates a
time’s serial value in units of 1/60th of a second.
Every time can be represented as a serial value
between 0 and 1.
A date and time, such as January 1, 2000, at noon,
consists of the date to the left of the decimal and a
time to the right. Take the example August 25, 2005,
at 5:46 PM. The date and time serial value is
38589.74028.
Subtracting one date from another involves subtracting
one serial value from another and then converting the
result back into a date or time.
F IND THE D IFFERENCE B ETWEEN
T WO T IMES
1
Type the first time in a cell.
Note: If you do not include AM or
PM, Excel defaults to a.m. If you
want p.m., you must type PM.
3
1
2
Type the second time in a cell.
3
2
Click in the cell in which you
want the results to appear.
4
Type an equal sign (=).
5
Click in the cell with the later
time.
6
Type a minus sign ( ).
7
Click in the cell with the earlier
time.
4
8
Press Enter.
6
7
5
48
Search JabSto ::

Custom Search