Greetings,

If I work six days in a row (A1:A6) in any given week, I get 1.5 times my regular pay for that sixth day alone (again, it has to be six days in a row in each week to qualify for that extra pay).

How do I have Calc look to see if all six days have hours and then calculate the six day’s hours at 1.5 it’s normal rate of pay per hour?

Thanks.