what is the formula I use in the formula builder for regular hours and overtime hours?

10. 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). NOTE: 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: All hours up to 40 hours are considered Regular Hours. If Total Hours are greater than 40, the first 40 are considered Regular Hours, with the remainder considered Overtime Hours Test your formula on your first two employees by typing various values in Total Hours to verify that it works as expected. A. Page Layout Fermer Der Merwe Ve Teile CIC Home int D Data A IT 0 FLOSS Foruder H . 10 You wy VAR IF LAR SRL we VA 114 OS Mere 1154 2510 HESI TE 12 SEL TE 23 14/23 A 14 WE 05 Vale WE 1121 754 Any *1750 TAME LE Care WITH Synas 30 TE . 11 34 + Paul Journal Cross ED Q PL 18 1 BE