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.

Calculate Hours Worked in Excel You can set up an Excel spreadsheet to track when employees work, essentially creating a timesheet in Excel.

The Autosum function can be used to add or sum Time in Microsoft Excel. You can add hours and calculate the total time in Excel.

Fortunately, Excel offers a built-in function, DATEDIF, which makes it easy to calculate elapsed calendar time.