Forum Discussion
Chart Display for Non-OT and OT values
Hi Experts, I have this table that has 3 columns: 1. Normal Hours 2. OT Hours 3. Employee Name I would need to calculate segregate the hours to display in the chart. How do i display both ...
Hi amitchandak,
My current table looks like this:
| Emp No | Job | Start Date | End Date | Normal Working Hrs | OT Hrs |
| Dave | Painting | 3-Jan | 3-Jan | 8 | 3 |
| Bob | Assembly | 4-Jan | 4-Jan | 10 | 0 |
| Jack | Maintenance | 5-Jan | 5-Jan | 8 | 6 |
On top of that, i have another table indicating the date for public holidays. Other than showing the normal working hours, OT hours, the trend of the OT hours in %, i would still need to limit my data according to:
1. Employees cannot work more than 12 hrs of overtime a day
2. Employees cannot exceed 44 hours OT in three weeks
3. Employees cannot work consecutively for 19 days (including PH and weekends)
4. Overtime a month cannot exceed 72 hrs (excluding PH and Sundays)
I would then need to visualize the above in a separate chart.