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

Setting up an Excel spreadsheet to calculate time worked. Follow these steps: In A1, enter Time In. In B1, enter Time Out. In C1, enter Hours Worked.

How to Calculate the Total Hours Formula in Excel. As a spreadsheet software program, Microsoft Excel has many useful features for a small business's productivity.