Below scenario we need help in setting up the working hour schedule:
- Employee is allowed to Punch IN and Punch OUT anytime between 7 AM to 5 PM. and he should follow the work schedule of 8 hrs only in between this time boundary of 10 hrs.
- If employee comes before 7 AM and any time time worked after 5 PM it should be excluded and not be considered in working hours of that day.
- If employee leaves early and not completed 8 hrs of work in office, it is to be considered as Shortfall.
- On any day his working hours should at least 8 hrs or max 10 hrs only even though he worked more than 10 hrs ( base don early punch in or late punch OUT).
- Schedule is without break and of 8 hours only.
- No OT allowed before 7 AM and after 8 hrs working too.
Few scenario to handle:
- Punch IN 6 AM and Punch OUT 2 PM= Normal Hours 7 hrs( 7 AM to 2 PM only) and 2 hours shortfall.
- Punch IN 6 AM and Punch OUT 6 PM= Normal Hours 10 hrs( 7 Am to 5 PM). Early 1 hr and last 1 hrs to excluded
- Punch IN 8 AM and Punch OUT 4 PM= Normal hours 8 hrs and 0 hrs shortfall
- Punch IN 9 AM and Punch OUT 6 PM= Normal hours 8 Hrs as last 1 hrs excluded
Summary: we need to exclude any time before 7 AM and after 5 PM from consideration in normal working hours.
Please suggest any solution.