Hi there
I have a sheet with arrival and departure times. The sheet has calculations to work out how many people where on the premises at a given time slot. I'd also like to longest waiting time at a given time slot. For example, at 08:00 there might be 5 people on the premises with the longest waiting time of these 5 people being 17 mins.
Thanks in advance.
Chart 1.xlsx
Bookmarks