Hi Everybody,
I'm new on the board.
I have a problem with ovelapping time and impossible to find a good solution.
I need to display the start hour and end hour of overlapping.
Bellow a sample:
The "What I need" column, is what I need
The row 2 is the reference time for overlapping.
The first sample, columns A:E is when the time doesn't exceed midnight and the second sample is when the end time exceed midnight.
I'm started to resolve this problem from this relfexion:
IF(OR(AND($A$2<=B6;$A$2>=A6);AND(A6<=$B$2;A6>=$A$2)); "Overlapping"; "No overlapping")
Sorry for my english, it's not my first language.
Thank you very much for your help.
JBL
I'm new on the board.
I have a problem with ovelapping time and impossible to find a good solution.
I need to display the start hour and end hour of overlapping.
Bellow a sample:
The "What I need" column, is what I need
The row 2 is the reference time for overlapping.
The first sample, columns A:E is when the time doesn't exceed midnight and the second sample is when the end time exceed midnight.
I'm started to resolve this problem from this relfexion:
IF(OR(AND($A$2<=B6;$A$2>=A6);AND(A6<=$B$2;A6>=$A$2)); "Overlapping"; "No overlapping")
Sorry for my english, it's not my first language.
Thank you very much for your help.
JBL
