tommyo94
asked on
Counting overlapping date/time
In Excel I need to be able to compute the number of times there are more than one unit on an incident and how many units end up on that incident. I have start and end (date/time) in separate columns. I'm guessing an array of some kind but not sure how to determine number of units on an incident
ASKER
Attached is a sample. Not looking for the count of units but the count of overlapping times.
Sample-of-Overlapping-Units.xlsx
Sample-of-Overlapping-Units.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Check in attached...do you mean like this? Else please upload a dummy/sample workbook.
Tommyo94_CountIFS.xlsx