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.