Counting incidents between two date/time columns
I have a set of data with a start date/time and end date/time and I want to count how many incidents are in motion at any given time. This seems quite simple as a manual task but has proven elusive as a spreadsheet formula.
I have tried COUNTIFS and SUMPRODUCT which seem to work but not accurately.
For clarity, if we have a start at 10/01/22 08:05 and end at 10/02/22 07:55 we could easily calculate how long that job has been in progress by simply subtracting. But I want to look at a list like this and answer the question, "How many cases are in progress at 12:00? at 13:00? etc."
MacBook Pro 15″, macOS 10.15