Hello all, I'm an excel novice so please bear with me.
I've made a schedule for my workplace where my colleagues shifts are stated in start time (column C, F, I etc...) and end time (column D, G...). After the start / end time, a calculation of the total worked hours is calculated and printed in light grey.
I want to create a table below that, where it shows the amount of present co-workers in each hour.
For example:
On monday, three guys are working the shifts: 15-23, 13-00 and 8-16.
I want a table that shows how many that are on the floor, during the days hours (00-24). Taken from above example, the output would be (in "normal" number):
(...)
Time | workers present
12-13: 1
13-14: 2
14-15: 2
15-16: 3
16-17: 2
17-18: 2
...and so on...
I've tried using countif and countifs, but to no avail. I suspect that it is getting messed up due the time format, specially since some cells have dates in them (which is neccesarly to count the totalt hours when the shift ends at 01 am). And I'm out of ideas, i've tried to solve this for four hours and I'm not getting anywhere. Would be very thankful for help in this matter!
Bookmarks