How to Calculate the Total Hours Formula in Excel. As a spreadsheet software program, ... You can use Excel to log the time that employees clock in and out of work using Excel.