Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Split of OT hours based on weighted average in the timecard — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Split of OT hours based on weighted average in the timecard

Received Response
14
Views
2
Comments
edited Nov 2, 2020 12:14PM in Workforce Management 2 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!