I am having trouble figuring out a formula for shift differential and I hope someone can help.
My shift diff. are base on the start of the shift. If I start at or after 2000 or before 0559 I will be paid non-premium rate. If I start at or after 1200 or before 1959 I will be paid a premium rate. These rates are for 8 hours or less of hours worked in one day.
My hours are start time E3 and end time F3
My premium shift start time is I3 and end time is J3
My non-premium start time is M3 and end time is N3
Bookmarks