You can even make use of Excel to calculate the difference between two times. It helps calculate the number of hours an employee worked between the given start and end time.

To calculate the difference between the "Clock In" time and "Clock Out" time, type the equals sign (=) in the cell below the "Total Hours" label (C2), click on the "Clock Out" cell to the left ...

Type the column headers "Total Hours" in cell I1, "Double Time Hours" in cell J1 and "Overtime Hours" in cell K1. Type the work start and end times for the first day of the work week.

To calculate hours worked, enter valid time values into B2 and C2. For example, enter 11:00 PM as the Time In and 7:00 AM as the Time Out, and Excel will display 8, the correct number of hours ...