How to Add Payroll Hours & Minutes in Excel. Excel considers dates and times as numbers in cells, making calculation difficult. Excel processes 6 AM as "0.25," because it is one quarter of the way ...

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.