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 ...

If you want to sum up the total number of hours using an Excel formula to calculate time worked, place a formula at the bottom of that column using the SUM function, summing up each row's entry ...

We explain how to fix the issue when Excel is not auto-calculating formulas. ... There are two methods that you can use to enable the auto-calculate option in Excel: Method 1: Go to the File tab.