Find time overlaps by name

[axeelcs]

Hi ! I have a data table like this :


I need a formula to analyze if there are overlaps in the times by employee.

I tried to use this formula :

[COLOR=#333333]SUMPRODUCT(--((A1+C1<=$A$1:$A$15+$B$1:$B$15)+(A1+B1>=$A$1:$A$15+$C$1:$C$15)=0))<>1[/COLOR]

But i couldn't adapt it to my needs.

Thanks !!!

 

[axeelcs]

Sorry for the image

 

[axeelcs]

Sorry for the image

Hi, i've been looking for some options and what I think I need its a dynamic range, so the function can determine overlaps time by groups:

Anybody can help me ?

 

[axeelcs]

Hi, i've been looking for some options and what I think I need its a dynamic range, so the function can determine overlaps time by groups:

Anybody can help me ?

Can anyone help me ?

 

[axeelcs]

Can anyone help me ?

Help ??