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