Hello all,
I'm new here and somewhat of an OK excel user. I am the director over an Ambulance service and I am trying to create a formula showing me how many times 2 or more of my trucks were busy on a call. I have a few different cells, A is the date of occurrence, B Time the call started, C time the truck was available, and D duration of time the truck was out of service. With those data sets, how can I generate a report to show overlapping calls where 2 or more trucks were out of service during the same time period?
Bookmarks