Split of OT hours based on weighted average in the timecard

Summary

Split of OT hours based on weighted average in the timecard

Content

Hi All

We have a need to split the OT hours in the employee's timecard based on the weighted average of the contribution from each assignment towards the total hours. 

Ex: An employee has 2 assignments, a teacher and a Custodian. 

Suppose the reported hours in timecard look like below

Teacher - 35 Hours

Custodian - 10 Hours

Total hours = 45

Regular Hours = 40

Overtime hours = 5

Split of overtime hours between the assignments should be like-

Teacher - Overtime Hours = 5 * (35/45) * 100 = 3.88 Hours

Custodian  - Overtime Hours = 5 * (10/45) * 100 = 1.11 Hours

This needs a formula to be written. If anyone has already done this, or has any idea to do this, please share your inputs with me, it will be really helpful.