Include the weekly nondiscretionary bonus in straight-time earnings, then divide by all hours worked to obtain the regular rate for overtime.
Read the case before entering a formula. The workbook separates input amounts from the result so a reviewer can trace your calculation. Use references rather than typing the displayed total. A hidden copy changes the inputs and checks that your approach still works. Compare the result with the stated period and wage base, then examine any cap or zero balance. A blank cell and a zero result mean different things. Keep the sign on reconciliation differences so another reviewer can tell whether the register is higher or lower.
Include the weekly nondiscretionary bonus in straight-time earnings, then divide by all hours worked to obtain the regular rate for overtime.