Number of overlapping times

I have a set of rows with a start time and end time each.  Each row represents the duration for usage of a resource.  What I need to understand is how many resources are in use for each row simultaneously.

 

Below, I can see that I had 2 in use 23 and 24 and then 2 again 25 and 26 at the same time.

 

Device ID Start Time  End Time

23 11/1/18 15:59:38 11/1/18 16:33:00

24 11/1/18 16:03:32 11/1/18 16:04:35

25 11/1/18 16:33:04 11/1/18 16:45:07

26 11/1/18 16:35:01 11/1/18 16:39:47

….

 

Thank You, Dan

 

By: Dan Watkins

Leave a Reply

Your email address will not be published. Required fields are marked *