Spreadsheet question: maximum simulanteous events
May 21, 2021 2:34 PM Subscribe
I have a spreadsheet for orders from a restaurant. It lists the start time in one column and the stop time in another column. It’s massive (covers an entire year). I would like to find, for every hour (or every 12 hours, or any other interval), the maximum number of orders that were open at the same time. Ie orders that were started, but not stopped. How would I do this in excel?