Hi,
I am needing a formula that will calculate the hours from cell: I through K and accumulate in column L (Regular Hours). Then once column L totals 40 hours, I need the additional hours to populate in to column N (Overtime Hours) and accumulate and then total.
Below is what I have so far and I appreciate any help at all from any of you because I can do simple formulas but that's it.
I am needing a formula that will calculate the hours from cell: I through K and accumulate in column L (Regular Hours). Then once column L totals 40 hours, I need the additional hours to populate in to column N (Overtime Hours) and accumulate and then total.
Below is what I have so far and I appreciate any help at all from any of you because I can do simple formulas but that's it.