All,
Having trouble figuring this one out...
I am trying to take a date and time and see how many times that date and time overlapped with other instances of that date and time. I have converted all times to military time.
Example:
--A--B--C--D--
--Start Date--Start Time--End Date--End Time--
ROW1--2/19/2010--9:00--2/19/2010--10:55--
ROW2--2/19/2010--9:03--2/19/2010--10:10--
ROW3--2/19/2010--10:01--2/19/2010--10:25--
ROW4--2/19/2010--10:26--2/19/2010--11:00--
If we look at the above example, the 3rd entry overlaps with the entire data set 2 times. I need a formula to count this in a large spreadsheet for all entries above and below each entry, for every entry. So an example result for each entry would be:
--A--B--C--D--E--
--Start Date--Start Time--End Date--End Time--# of times overlap--
ROW1--2/19/2010--9:00--2/19/2010--10:55--3
ROW2--2/19/2010--9:03--2/19/2010--10:10--2
ROW3--2/19/2010--10:01--2/19/2010--10:25--2
ROW4--2/19/2010--10:26--2/19/2010--11:00--1
Any Help on this would be greatly appreciated!
Bookmarks