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

Overtime Calculation with Absences for Bi-Weekly Time Card

Received Response
30
Views
5
Comments
edited May 7, 2020 12:23AM in Workforce Management 5 comments

Content

Hello Experts,

We have a bi-weekly timecard. When we calculate Overtime, the calculation has to be weekly.

Was able to modify the Oracle Overtime Fast Formula to achieve this, but the issue is when we have to calculate Overtime with Absences.

The OT is calculated at the end of the second week, but we need the OT to calculate on weekly basis.

Weekly Threshold = 40

Entered Value

  Monday Tuesday Wednesday Thursday Friday     Monday Tuesday Wednesday Thursday Friday
Regular 8 10 10 8       8 8 10 8  
Vacation         8             8

 

Calculated Entry

  Monday Tuesday Wednesday Thursday Friday     Monday Tuesday Wednesday Thursday Friday
Regular 8 10 10 4       8 8 10   4
Vacation         8           8  
Overtime         4             4


Has anyone done this?

Thanks

SG

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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