Open a new spreadsheet in Microsoft Excel. Enter the number of hours worked in cell A1. As an example, you might enter "48." Enter the normal hourly wage in cell A2.

To calculate the difference between the "Clock In" time and "Clock Out" time, type the equals sign (=) in the cell below the "Total Hours" label (C2), click on the "Clock Out" cell to the left ...

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.