Hi, I have a most similar question that I cannot seem to work with formula. I have a list of just over 100 call log entries. I need to calculate how many calls have overlapped. Times are recorded in military time. Each list is based on a 24 hour period.

Columns are:
E. Start time
Q. End time
R. Duration

Please note I have read the earlier threads on this topic and those are customized for a different set of rules.

When I say overlapped, I mean:
If any rows' start, elapsed/duration or end time is equal to any other rows start, elapsed/duration or end time.

Any help is greatly appreciated.