kamashal
New member
- Joined
- Feb 13, 2019
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
This is little complicated and i need desperate help from someone..
In the schedule sheet i have schedule date and Overtime hours. Wherever the hours are updated (hh:mm:ss) it means associates worked for 9 hours.
In the Overtime columns those are actual over time worked by the associate.
In the reports sheet, whenever i select from and to date, associate total hours should reflect eliminating Absent (A), Planned leave (PL) and off hours. Total hours will be 9 hours working hours and it should add the over time hours.
Can some help on this please?View attachment Calculation.xlsx
In the schedule sheet i have schedule date and Overtime hours. Wherever the hours are updated (hh:mm:ss) it means associates worked for 9 hours.
In the Overtime columns those are actual over time worked by the associate.
In the reports sheet, whenever i select from and to date, associate total hours should reflect eliminating Absent (A), Planned leave (PL) and off hours. Total hours will be 9 hours working hours and it should add the over time hours.
Can some help on this please?View attachment Calculation.xlsx