Calculation of overtime on weekly basis

766 Views

Current Scenario:

Currently the system is calculating overtime but this is on daily basis , and transferring the extra hours to time type . Now after that it is going to the Overtime quota on daily basis .

Requirement :

Basically the requirement is to transfer the overtime on weekly basis . Let me explain with a example:

Currently if the planned working hours say 8 hours and employee recorded 10 hours then 2 hours is added to the overtime quota .

We need to make this calculation weekly, if the weekly planned working time is 40 hours and the employee worked for 48 hours then 8 hours would be overtime .

In my current scenario :

Monday Tuesday Wednesday Thursday Friday Saturday Sunday Planned working time 8 8 8 8 8 0 0 Employee recorded working hour 4 10 10 8 8 0 0 Overtime 2 2

My requirement is that for the above example the total planned working time sis 40 hours and the employee recorded 40 hours so there should not be any overtime recorded.

I suppose this cannot be done by customization ( if any please advice )

I understand that we need a PCR to first calculate the difference between weekly time sheet recorded and the weekly planned working time . Please advice on this grounds how can we proceed .