Please see attached 2018.3 workbook which partially addresses Question 2: How many employees are in Break Room at same time/hour. by date.
However there aren't any time parameters given to determine SHIFT.
You'll still be able to see all of the the underlying data which makes up the data point, by right clicking on the data point as shown below:
However, for the first question...I don't know...much harder to do and answer that question in a good and reliable format due to the complexity of the number of rooms involved. I see lot's of problems if using table calcs and summing of time isn't easy, especially when it crosses over a 24-hour period of time (i.e., Shifts). I think the only way to answer your question by each room is through table calcs so it might be a very frustrating exercise to accomplish.
Just the same, if you can provide your parameters for what a shift would be, that would be a start. Also, do you have an idea as to how you'd want the final outcome to look like? It might help others to think about possible solutions and I'll think through some things myself...
Time Calculation.twbx 721.6 KB