Overtime computation

Hi everyone;

This is to re-phrase my old post. What I have is an overtime (OT) template that identifies the number of hours and minutes in different OT claim (i.e. Regular OT, Special OT, and Legal OT) Each type will be dependent to the work time schedule and on the holiday table. What I want to accomplish is to: be able to make the OT template to compute the total hours and minutes in the right type of OT claim. For the Night Differential (ND) will only commence at 10:00 PM until 6:00 AM of the following day. Kindly see my attached file for sample.

Hope you could help me with this.


Thank you so much.