Please see attached. All hours are rounded in 15 min increments, and on all days except Sunday, shift differential is applied from 17:00hrs to 01:00 hrs of the following morning. On Sundays, however, all hours are paid with shift differential.
Please see attached. All hours are rounded in 15 min increments, and on all days except Sunday, shift differential is applied from 17:00hrs to 01:00 hrs of the following morning. On Sundays, however, all hours are paid with shift differential.
In J3:
=IF(A3="Sunday",G3,MOD(F3-C3,1)-(C3>F3)*MEDIAN(0,F3-6/24,6/12)-MAX(0,MIN(17/24,F3+(C3>F3))-MAX(5/24,C3)))
?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks