Hourly/daily Resource counter

Hello all,

I am trying to document all the individual dates & times the various resources in my team work. Since we are 24x7, there are people working at any given hour on any given day. I need assistance in creating a formula to track how many resources would be on shift at any given hour on any given day.

I am completely open to changing the formatting of this data if it makes generating the formula any easier. At the end of the day, all i need to see is:

• Employee Name
• Days Staffed
• Shift Start Time
• Shift End Time
• Updated table on the right counting all the resources working each hour each day (J3:P26)

Thank you everyone for your assistance, and please let me know if there are any questions!

Staffing.xlsx