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