So I found this formula online. It calculates the Overtime hours on Fridays and Saturdays.
Formula:
=CHOOSE(MAX(WEEKDAY(A2),4)-3,0,IF(C2< B2,C2,0)*24,D2,(IF(C2< B2,1,C2)-B2)*24)
However it does not work properly. When it is friday it only displays 0.42
So I want to change it so it only displays OT on saturdays. And I want another one that displays OT on sundays(different pay).
Can somebody help me with this?
P.S. any suggestions with the G column?
Bookmarks