Have a wage formula but need an IF statement to calculate shift diff on Sundays

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)))

?

Originally Posted by brokenbiscuits

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)))

?

Awesome that works perfectly!!!! Thank you. Is there a way to make it do that if it does not equal Sunday then keep the same rounding parameters and shift differential set up that i already have? i.e. Shift diff all other days of the week from 17:00-01:00