In the Regular Hours and Overtime Hours columns of your Payroll Journal worksheet, create

formulas that will calculate regular and overtime hours based on the total hours value entered in

the Total Hours column $($your company considers any hours over $40$ worked in a standard work

week to be overtime hours$)$ and will $$spill$$ over for all employees. You will use the IF function

$$

to test whether or not the employee worked overtime. Use the following overtime rule to guide

your function:

$$ Regular hours: For up to $40$ hours, Regular Hours should equal Total Hours. For more

than $40$ Total Hours, Regular Hours should be $40.$