0
Sep 08, 2014 at 07:27 AM

# Daily working hours calculation but Half an hour flexi before start of planned time & shortfall hours calculation

609 Views

Dear All,

I want to calculate daily working hours but Half an hour flexi before start of planned time & shortfall hours calculation if a person didn't completed 9 hours job.

We have different types of DWS, PWS & WSR for different PS/PSA & EG/ESG groupings.

We have a requirement for Executives/Officers (E0-E8/ S1-S2) for only one PSA (1100) for only one DWS(GFLX). In this requirement I want to calculate daily working hours but Half an hour flexi before start of planned time & shortfall hours calculation if a person didn't completed 9 hours job.

Please see the requirement and my configured DWS and PCR's in detail with example and suggest me the solution:-

Overview

I want to calculate (Please take the reference from DWS screenshot)

1. daily working hours, but starting from first Begin Tolerance Time
2. Shortfall of hours if 9 hours not completed, but again starting from first Begin Tolerance Time, although employee has come before Begin Tolerance Time

I've configured one DWS as below,

Requirement:-

The planned shift timings is 9:30 - 18:30. Employees should work and complete 9 hrs in a day, but this 9 hours should be counted only from 9:00 (i.e. Begin tolerance time). It means. In time should not consider before 9:00.

1. Suppose 1st day employee punch In time is 9:00 then he has to work up to 18:00, then only 9 hours of working will be completed & no shortfall will be calculated.

In above case, if Out time is 17:00 then shortfall will be calculated 1.0 hours, because his working hours will be counted 8 hrs only.

2. Suppose 2nd day employee punch In time is 9:45 then he has to work up to 18:45, then only 9 hours of working will be completed & no shortfall will be calculated.

In above case, if Out time is 18:00 then shortfall will be calculated 0.75 hours, because his working hours will be counted 8.25 hrs only.

3. Suppose 3rd day employee punch In time is 8:30 then he has to work up to 18:00, then only 9 hours of working will be completed & no shortfall will be calculated. (In between 9:00 - 18:00 ). Here In time is 8:30 but system should consider and count from 9:00.

In above case, if Out time is 17:30 then shortfall will be calculated 0.5 hours, although he has worked 9 hrs.

4. Suppose 4th day employee punch In time is 10:11 then he will be marked as Late Come(as per DWS) and then he has to work up to 19:11, then only no shortfall will be calculated, because he completed 9 hours.

Now the below PCR is calculating Daily Working Hours,

Now the below PCR is calculating Late Coming Hours,

Overview

I know that use of begin tolerance time is different in from my requirement. Please guide me if this DWS configuration will not work.

As of now system is able to calculate Daily Working Hours (but not from the begin tolerance time), Late coming days and Late coming hours, but shortfall is not getting calculate properly.

Please give me the idea how to write PCR for these requirement, I know that my ZDHR PCR (Daily Working Hours) needs to change or replace to fulfill this requirements.

If you want any other details please let me know.

Best Regards,

Deepak

Attachments

DWS.jpg (36.9 kB)
ZDHR.jpg (14.7 kB)
ZLTH.jpg (57.7 kB)