Counting Overlapping Time & Non-Overlapping Time

Hey guys,

I could use some help with my attached spreadsheet.

There is a list of data with some overlapping times, some not. I want my first formula to locate the times that there is no activity [non-overlapping times] +/- "H2" minutes and calculate how long there is no activity [which it does]

Now I need a formula to calculate the length of activity from the start time until there is a break of greater than "H2" minutes.

Right now, I have this:

Please Login or Register  to view this content.

IF E5+F5<D6 AND H5>=0, THEN ???????, if not, be blank.

I simply don't know what command should be here; I played with LOOKUPs, VLOOKUPs, MIN & some calculations, MAX & some calculations, but i'm just at a loss...

Hopefully someone can help!

Thanks in advance!