calculating overtime hours with including week off/Holidays for the operatives!

Required a formula help for calculating overtime hours for the operatives with the following below steps.


1. In a column H (Header Normal Hours) only return a hours between 0.1 to 3.5 after calculating the headers Finish time (Column G) to start time (Column H), whatever exceeded other than 3.5 to be return in column I (Additional/Fridays/Holidays).

2. The Fridays and holidays all working hours always to be return in a column I (Additional/Fridays/Holidays).

3. The paid amount to be return in a Column K by calculating hours (Normal and Holidays) with different rates mentioned in cells M3:M4.



Thanks for the help,