Can we change the following data to the desired output.
Code | Shift Start Time | Shift End Time | Duration | ||
Huddle | 8:00 | 16:30 | 8:30 | ||
Huddle | 10:00 | 19:00 | 9:00 | ||
Huddle | 8:00 | 17:00 | 9:00 | ||
Huddle | 8:00 | 17:00 | 9:00 | ||
Huddle | 9:30 | 18:30 | 9:00 | ||
Huddle | 8:00 | 17:00 | 9:00 | ||
Huddle | 8:00 | 17:00 | 9:00 | ||
Huddle | 8:00 | 17:00 | 9:00 | ||
Huddle | 7:00 | 16:00 | 9:00 | ||
Huddle | 10:00 | 19:00 | 9:00 | ||
Huddle | 9:00 | 18:00 | 9:00 | ||
Huddle | 9:00 | 18:00 | 9:00 | ||
Huddle | 8:00 | 16:30 | 8:30 | ||
Huddle | 9:00 | 17:30 | 8:30 | ||
Huddle | 8:00 | 16:30 | 8:30 | ||
Huddle | 9:00 | 17:30 | 8:30 | ||
Huddle | 9:00 | 18:00 | 9:00 | ||
Desired Output
Interval | Heads | ||
7:00 | 1 | ||
7:30 | 1 | ||
8:00 | 9 | ||
8:30 | 9 | ||
9:00 | 13 | ||
9:30 | 14 | ||
10:00 | 16 | ||
10:30 | 16 | ||
11:00 | 16 | ||
11:30 | 16 | ||
12:00 | 16 | ||
12:30 | 16 | ||
13:00 | 16 | ||
13:30 | 16 | ||
14:00 | 16 | ||
14:30 | 16 | ||
15:00 | 16 | ||
15:30 | 16 | ||
16:00 | 15 | ||
16:30 | 12 | ||
17:00 | 7 | ||
17:30 | 6 | ||
18:00 | 3 | ||
18:30 | 2 | ||