Calculating the Difference Between Hours

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