I'm thinking this is a pretty easy one.
I am doing a new schedule at work and if the total number of hours in a work week are greater than 80, then it will need to be calculated with overtime.
basically what I am trying to think of is; the result is 84, then 80*x=y, then the 4 remaining hours would be 4*1.5x=w, then add them together to get a total, y+w=total earnings
anything over 80 would be time and one half.
I am using this formula to count the days worked, 1 being first shift and 2 being second shift; =(SUM(COUNTIF(I13:V13,{1,2}))*12)
I am doing a new schedule at work and if the total number of hours in a work week are greater than 80, then it will need to be calculated with overtime.
basically what I am trying to think of is; the result is 84, then 80*x=y, then the 4 remaining hours would be 4*1.5x=w, then add them together to get a total, y+w=total earnings
anything over 80 would be time and one half.
I am using this formula to count the days worked, 1 being first shift and 2 being second shift; =(SUM(COUNTIF(I13:V13,{1,2}))*12)