Type the formula in cell K2 to calculate overtime hours for the week. This formula will test to see if the total hours worked that week, minus the total double time hours, is greater than 40.

To solve this problem, Excel allows conditional calculations so that you can calculate the normal rate for up to 40 hours worked and then a higher amount for overtime hours worked. Open a new ...

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 overtime at 1.5 times the regular rate for hours over 40. For instance, if a server earns $300 in tips and $400 in base pay for a 50-hour week, the calculation would be: Total earnings ...