Calculate the worked overtime depending on two criteria

Hey guys and girls,

I need your help once again.

Person 1 works 4 days a week. Always from Monday till Thursday.
When he works during D(ay)-shift (see W05), he has to work minimum 8 hours on Monday, Tuesday and Wednesday and 7.2 hours on Thursday.
When he works during L(ate)-shift (see W04), he has to work minimum 7.2 hours on Monday and 8 hours on Tuesday, Wednesday and Thursday.

In cell F10 i need to adjust the existing formula (which calculates the hours in excess of standard weeks, like written above) so it will see the difference between D(ay)-shift and L(ate)-shift.
The correct return of the formula in cell C10 should have to be 4.3 like calculated manually in cell F11

Do you have any ideas??


Tank in advance!!


Alex