I am attempting to create a time sheet for employees to provide total hours entered for each day of the week and have the hours split between three pay rates.
M-F first 8 hours are regular pay; next 2 would be at time and half; after 10 hours - Double Time.
Saturday is at time an half
Sunday is at Double Time
I am having an issue with the time and half calculation, if the employee works a 12 hour day, double time is calculated correctly, but the two hours at time and half are added back to the regular hours.
What formula can I use to replace mine so 2 hours of time and half gets picked up for a 12+ hour day?
Bookmarks