This is where we start making spreadsheet magic. Assuming you haven’t removed or added any days to your spreadsheet, HOURS THIS WEEK should be in cell G16, while TOTAL should be in cell K19.
Step 1: Prepare to add formulas for digital use
Follow instructions from step 5, then highlight cells H16 over L16 and down to row 18. Turn these and cell L19 gray. Now the boxes with your calculations will stand out from the rest of the employee’s timesheet entrees.
Step 2: Click on cell H16 or whatever cell is directly beside the box that says HOURS THIS WEEK. In the formula bar, type in =SUM(H9:H15) and press Enter. This box will now add any numbers entered in the column labeled TOTAL (HOURS).
Step 3: Click on cell I16. In the formula bar, type in =SUM(I9:I15) and press Enter. This box will now add any numbers entered in the column labeled OVERTIME (HOURS).
Step 4: Click on cell J16. In the formula bar, type in =SUM(J9:J15) and press Enter. This box will now add any numbers entered in the column labeled SICK (HOURS).
Step 5: Click on cell K16. In the formula bar, type in =SUM(K9:K15) and press Enter. This box will now add any numbers entered in the column labeled HOLIDAY (HOURS).
Step 6: Click on cell L16. In the formula bar, type in =SUM(L9:L15) and press Enter. This box will now add any numbers entered in the column labeled VACATION (HOURS).
Step 7: In cell H17 (or whatever cell is directly beside RATE), type in the employee’s hourly rate. In the cell beside that, type in the employee’s overtime rate.
If your business provides paid time off (PTO) for sick time, vacations, and holidays, fill J17, K17, and L17 with the employee’s standard hourly rate.
As an example, if your employee makes $10 per hour, the bottom of your spreadsheet will look like this: