Hello,
I am at a full standstill trying to get the right functions to operate.
Here are the parameters of the time sheet that I'm trying to fit.
-8 hour work day (REG), anything past 8 REG = overtime OT,
-overtime (or a combination of REG and OT totaling 12) past 12 hours = Double time DT
-40 hour work week, ANY hours worked past 40 go directly to the overtime column
I am trying to make column I (REG) display totals only up to 40. I9 to I15= 39.25, so I16 should equal 0.75, J16 should add 7.25 and I17 should be 0/blank and the total of I17 (8) added to J17 (4).
The problem i'm hitting is that when I make an IF statement reacting to the 40 hour week overflow in column I, it affects all the items in that column with the formula. Is there a better way to do a sequential sum to 40 in column I (REG) with overflow in column J (OT) PLUS a combined row sum of each I + J cells totaling 12 and the overflow past 12 (of I + J cells in each row) to add to column K (DT).
If you can mention to me a function that can do this let me know, else I have to look at how to script it with the VBA with my amateur knowledge.
ts.png
Bookmarks