# Calculating Saturday overtime rates on a timesheet in Excel

0

Hi all\

Our workers are paid as follows on a Saturday:

Time and a half for first 2 hours, then double time after that

Sunday:

Double time

How can I write a formula to split out the total hours? I already have a formula for calculating overtime during the week (ie after 8 hours), it is just the weekend rates!

Thanks

0

it would be best to see an example of what you're currently doing/ using to prepare your formula, however, you could create a formula that determins whether or not the day is Sat or Sunday and from there create separate formulas for if Sat is Less Than or Equal (LTE) to 2 multiply by 1.5 then take remainder times 2 (double time); and for Sunday multiply by 2 for double time.

Using the "= Weekday" formula, you can determine what day it is (helping you get the sat or sundays you need and corresponding multipliers.  OR at time of entry you could have 2 separate columns on Sat (one for the LTE 2 yours and the other column for the remainder if any).

if you found this useful, please give credit.  Hopefully this also gives you some ideas as well.