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.

Calculate Hours Worked in Excel. You can set up an Excel spreadsheet to track when employees work, essentially creating a timesheet in Excel. Advertisement. Article continues below this ad.

Calculate Work Hours and Pay Writers for Indeed explain how to calculate the hours that employees have worked. If the company uses timesheets, you need to convert the entered times to military time.