Overtime Calculation with Absences for Bi-Weekly Time Card
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:
0