R
Rick.
I'm working on a formula for Split Shift (SS), Having different hourly rates
and different hours worked.
For example, Rate 1: @ $8.25/hr if the employee (EE) worked from 4:00 hrs to
4:59 hrs the SS is $7.00, if the EE worked from 5:00 hrs to 5:59 hrs then the
SS is $6.75 and so on up to 10:59 hrs.
Rate 2: @ $9.00/hr if the EE worked from 4:00 to 4:59 hrs the SS is $4.00,
if the EE worked from 5:00 to 5:59 hrs then the SS is $3.00 and so on up to
10:59 hrs.
I have several rates, how can I include all of them in the formula?
This is my formula so far:
=IF((A18=8.25)*AND(B18>=4)*(B18<5),"7",IF((B18>=5)*(B18<6),"6.75",IF((B18>=6)*(B18<7),"6.50",IF((B18>=7)*(B18<8),"6.25",IF((B18>=8)*(B18<9),"6",IF((B18>=9)*(B18<10),"5.75",IF((B18>=10)*(B18<11),"5.50",)))))))
Thanks in advance for your help.
Rick
and different hours worked.
For example, Rate 1: @ $8.25/hr if the employee (EE) worked from 4:00 hrs to
4:59 hrs the SS is $7.00, if the EE worked from 5:00 hrs to 5:59 hrs then the
SS is $6.75 and so on up to 10:59 hrs.
Rate 2: @ $9.00/hr if the EE worked from 4:00 to 4:59 hrs the SS is $4.00,
if the EE worked from 5:00 to 5:59 hrs then the SS is $3.00 and so on up to
10:59 hrs.
I have several rates, how can I include all of them in the formula?
This is my formula so far:
=IF((A18=8.25)*AND(B18>=4)*(B18<5),"7",IF((B18>=5)*(B18<6),"6.75",IF((B18>=6)*(B18<7),"6.50",IF((B18>=7)*(B18<8),"6.25",IF((B18>=8)*(B18<9),"6",IF((B18>=9)*(B18<10),"5.75",IF((B18>=10)*(B18<11),"5.50",)))))))
Thanks in advance for your help.
Rick