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.