I have a shift roster like
and the roster format as
with respect to date how can we get the actual emp counts hourly. hourly will be 0 to 23.
for eg. 8am count will be 1 shift A
10am count will be 2 shift (A&B)
I am not able to fig out. any help
Result
Shift Flag | A | B | C | D | E |
Shift Start Time | 8:00:00 | 10:00:00 | 12:00:00 | 16:00:00 | 0:00:00 |
Shift End Time | 16:00:00 | 18:00:00 | 20:00:00 | 0:00:00 | 8:00:00 |
and the roster format as
Date | Day | Week Day | Emp 1 | Emp 2 | Emp 3 | Emp 4 | Emp 5 | Emp 6 |
19-Nov | Sunday | WK-DAY | A | D | C | B | D | E |
20-Nov | Sunday | WK-DAY | WO | D | C | B | D | E |
21-Nov | Sunday | WK-DAY | WO | D | C | B | D | E |
22-Nov | Sunday | WK-DAY | E | WO | WO | A | D | WO |
with respect to date how can we get the actual emp counts hourly. hourly will be 0 to 23.
for eg. 8am count will be 1 shift A
10am count will be 2 shift (A&B)
I am not able to fig out. any help
Result
Hours | Agent Count |
0 | Count of agent here |
1 | |
2 | |
3 | |
4 | |
5 | |
6 | |
7 | |
8 | |
9 | |
10 | |
11 |