Overlapping Time Based on Conditions

Welcome to the forum! See if the attachment does the trick. I reformatted your sheet to display seconds in columns B and C, then I added a helper column labeled "Team" in Column F with a table off to the side to help match each entry to the associated team. The real work occurs in column G, which uses the following formula in G2, filled down through G357:

=IF(COUNTIFS($C$2:$C2,">"&$B2,$B$2:$B2,"<"&$C2,$F$2:$F2,$F2)>1,MIN(SUMPRODUCT(--($C$1:$C1>$B2),--($B$1:$B1<$C2),--($F$1:$F1=$F2),($C$1:$C1)),$C2)-$B2,"")

This should show the overlap time in the row of the second of the two overlapping entries. I didn't check every entry, but it seemed to work on the ones I looked at. Take a look, hopefully it helps...


EDIT: Better solutions below