Splitting overtime across Cost Centers

Summary

Need to record time based on cost centers and then split the overtime and assign it to the respective cost centers

Content

We have a requirement where the client has employees who have a home cost center but can work in other cost centers as well. Any time recorded in other cost centers that goes to overtime must be associated with the respective cost center. (see attached excel)

The home cost center must be considered first in all calculations. 

Has any one had a similar requirement and did you use a delivered template to meet this or did you use a custom formula based template