I am trying to figure out a formula for calculating regular hours based on 2 different pay rates within the same week.
Ex. On 11/20/2019 the pay rate is $12.50 and I worked 4:00pm - 2:30am which is equal to 10.5 hours. The total pay for that day would be 12.50*10.5 which equals 131.25. Now, lets say they raise the pay rate to $16.50 on 11/21/2019 and stays that rate for the rest of the time. And for that day I worked 4:00 pm - 2:30am again with 10.5 hours. The pay for that day would be $173.25. So I set up a formula for regulars meaning up to 40 hours. The question I have now is, how would you calculate the total pay with the total hours I have right now, which is 21 hours to the different pay rates? Would you use the 12.50 or the 16.50? Or Both? If both, then how would you formulate it?
Bookmarks