Need help with overlapping times

**k.mack0215** · 10-14-2013, 12:16 PM

Hi!

I need some help figuring out a formula- essentially I need to find out when times are overlapping. Once those are found- I need to count how many happen total.

It's probably super simple-but i'm not entirely savvy when it comes to formulas.
Zeag Report.xls

Any help would be greatly appreciated!!

-Kayla

**sktneer** · 10-14-2013, 04:19 PM

You can use this formula in Cell M16

=COUNTIF($I:$I,C16)

**k.mack0215** · 10-15-2013, 10:50 AM

Thank you for your response!!
I tried that- but I think my excel sheet was messed up. Here is an updated(simplified) spreadsheet.

Again I'm looking for a formula that helps me figure out how many overlapping occurrences happen in one day.

Any help would be great! Or if you can try and help me understand writing a formula!

[ATTACH]271157[/ATTACH