» Calculating the Difference Between Hours
CATEGORY - Excel Time
VERSION - All Microsoft Excel Versions
To calculate an employee's working hours:Enter the following formula into a cell:
=D4-C4+IF(C4D4,1)
The number 1 in the IF formula equals 24 when working with time.
For example, in row 6, the calculation is
6.00 - 20.31+ 24.00 = 9.29.

Book Store:
Recommended Books:
No comments have been submitted.

