Wage spreadsheet for hours

Hello and welcome to the forum.

E4:

Formula:

=IF(WEEKDAY(B4,2)<6,IF(AND(D4<C4,C4<0.75),0.75-C4,MAX(0,MIN(D4,0.75)-MAX(C4,0.25))),0)

F4:

Formula:

=IF(WEEKDAY(B4,2)<6,D4-C4-E4+IF(D4<C4,1,0),0)

G4:

Formula:

=IF(WEEKDAY(B4,2)=6,D4-C4+IF(D4<C4,1,0),0)

H4:

Formula:

=IF(WEEKDAY(B4,2)=7,D4-C4+IF(D4<C4,1,0),0)

Then copy down.