Forum Discussion
Non productive hours calculation
From the attached data, if any employee on leave then non productive hours should be blank or shoud not take into consideration and for rest sum of NPT hours to be calculated. Name Code Date...
| Name | Code | Date | Times - Start Time | Times - Stop Time | Times - Duration | NPT Time | Actual AHT |
| E | Meeting | 5/1/2023 | 12:00 | 12:15 | 0:15 | 0.25 | 0.00 |
| E | SL | 5/1/2023 | 09:00 | 18:00 | 8:00 | 8 | 0.00 |
| E | Meeting | 5/1/2023 | 16:00 | 16:15 | 0:15 | 0.25 | 0.00 |
| B | Meeting | 5/1/2023 | 09:00 | 09:19 | 0:19 | 0.316667 | 0.32 |
| B | Meeting | 5/1/2023 | 12:00 | 12:15 | 0:15 | 0.25 | 0.25 |
| B | PL | 5/2/2023 | 09:00 | 18:00 | 8:00 | 8 | |
| B | Meeting | 5/2/2023 | 16:00 | 16:15 | 0:15 | 0.25 | |
| H | SHIFT | 5/1/2023 | 09:00 | 18:00 | 9:00 | 9 | |
| H | Training | 5/1/2023 | 12:00 | 12:15 | 0:15 | 0.25 | |
| H | PL | 5/2/2023 | 09:00 | 18:00 | 8:00 | 8 | |
| I | Meeting | 5/1/2023 | 16:00 | 16:15 | 0:15 | 0.25 | |
| K | SHIFT | 5/1/2023 | 09:00 | 18:00 | 9:00 | 9 | |
| K | Training | 5/1/2023 | 12:00 | 12:15 | 0:15 | 0.25 | |
| K | CL | 5/3/2023 | 09:00 | 18:00 | 8:00 | 8 | |
| K | Meeting | 5/1/2023 | 16:00 | 16:15 | 0:15 | 0.25 | |
| F | Training | 5/1/2023 | 12:00 | 12:15 | 0:15 | 0.25 | |
| F | SL | 5/1/2023 | 09:00 | 18:00 | 8:00 | 8 | |
| F | Meeting | 5/1/2023 | 16:00 | 16:15 | 0:15 | 0.25 | |
| G | Training | 5/1/2023 | 12:00 | 12:15 | 0:15 | 0.25 | |
| G | CL | 5/1/2023 | 09:00 | 18:00 | 8:00 | 8 | |
| G | Meeting | 5/1/2023 | 16:00 | 16:15 | 0:15 | 0.25 | |
| J | Training | 5/1/2023 | 12:00 | 12:15 | 0:15 | 0.25 | |
| J | PL | 5/1/2023 | 09:00 | 18:00 | 8:00 | 8 | |
| J | Meeting | 5/1/2023 | 16:00 | 16:15 | 0:15 | 0.25 | |
| C | Meeting | 5/1/2023 | 12:00 | 12:15 | 0:15 | 0.25 | |
| C | CL | 5/3/2023 | 09:00 | 18:00 | 8:00 | 8 | |
| C | Meeting | 5/1/2023 | 16:00 | 16:15 | 0:15 | 0.25 | |
| I | Meeting | 5/1/2023 | 12:00 | 12:15 | 0:15 | 0.25 | |
| I | SL | 5/1/2023 | 09:00 | 18:00 | 8:00 | 8 | |
| I | Meeting | 5/1/2023 | 16:00 | 16:15 | 0:15 | 0.25 | |
| D | SHIFT | 5/1/2023 | 09:00 | 18:00 | 9:00 | 9 | |
| D | Meeting | 5/1/2023 | 12:00 | 12:15 | 0:15 | 0.25 | |
| D | SL | 5/4/2023 | 09:00 | 18:00 | 8:00 | 8 | |
| D | Meeting | 5/1/2023 | 16:00 | 16:15 | 0:15 | 0.25 | |
| A | Meeting | 5/1/2023 | 12:00 | 12:15 | 0:15 | 0.25 | |
| A | SL | 5/1/2023 | 09:00 | 18:00 | 8:00 | 8 | |
| A | Meeting | 5/1/2023 | 16:00 | 16:15 | 0:15 | 0.25 |