Count number of FTEs by hour of day based on their Shift

[le3fou1]

Hi,

I would like your assistance in figuring out what the total FTEs working at a particular hour based on their shift.

For example, if a worker A is working from 8:00 a.m. to 4:00 p.m. and another worker B is working from 10 a.m. to 6:00 p.m. it would display the table in this format:

8:00 a.m. - 9:00 a.m. = 1

9:00 a.m. - 10:00 a.m. = 1

10:00 a.m. - 11:00 a.m. = 2

11:00 a.m. - 12:00 a.m. = 2

and so on and so forth. I would to use this to compare our existing schedule compared to the incoming volume at the hourly level.

I appreciate your help!

Best,

FL

[#2]

@le3fou1 

Can a shift extend past midnight, e.g. worker C works from 10:00 pm to 6:00 am the next day?