Could anyone walk me through the functions needed for creating a matrix that would look at a schedule worksheet and tell me the number of people that are working at a specified time? Say I have a full schedule, I want it to do similar to a tally for every hour like how many people working at 04:30, then how many people working at 05:00 and so on? I think it would be something to do with the COUNTIF function but I'm not sure syntax. I dont know anything about arrays or macros but possibly I might need one of these to do the trick. ANY HELP APPRECIATED!!!
Bookmarks