Repair a function Choose, weekday, if formula.

So I found this formula online. It calculates the Overtime hours on Fridays and Saturdays.

Formula:

Please Login or Register  to view this content.

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?

You can calc the overall weekend hour with this...
=IF(WEEKDAY($A2,2)<6,0,C2-B2)
for weekday hours, use...
=IF(WEEKDAY($A2,2)>5,0,C2-B2)

Once you have these hours, you should be able to break out normal and OT hours

Originally Posted by FDibbins

You can calc the overall weekend hour with this...
=IF(WEEKDAY($A2,2)<6,0,C2-B2)
for weekday hours, use...
=IF(WEEKDAY($A2,2)>5,0,C2-B2)

Once you have these hours, you should be able to break out normal and OT hours

That worked like a charm. Do you have any tips on calculating the OT before 5 AM?

Edit:
Nevermind, I made an if statement that does that.

=IF(C3>"05:00",SUM("05:00"-C3),0)

Thanks a million!

For before 5:00 am, try this...
=IF(B2>=5/24,"",5/24-B2)

After 5Pm, try this...
=IF(C2>17/24,C2-17/24,"")