Hi,
I have a data table as follows :
COLUMN A - Date
COLUMN B - Start
COLUMN C - Finish
COLUMN D - Total time
I need a formula to site in COLUMN L that will highlight (TRUE/FALSE) if there are overlaps in the times, specific to date.
THIS LIST IS SUBJECT TO SORTING AND SO THE FORMULA IN COLUMN F MUST USE OFFSET, or a full array to analyse the data and take into account the date.
e.g.
26/10/2009...09:00....13:00
26/10/2009...13:00....13:45
26/10/2009...13:40....16:00 overlap
26/10/2009...15:45....18:00 overlap
26/10/2009...18:15....19:00
27/10/2009...09:15....10:00
27/10/2009...10:00....13:00
27/10/2009...13:00....15:00
27/10/2009...15:00....16:00
Would be an amazing help!!!
Best regards
T
I have a data table as follows :
COLUMN A - Date
COLUMN B - Start
COLUMN C - Finish
COLUMN D - Total time
I need a formula to site in COLUMN L that will highlight (TRUE/FALSE) if there are overlaps in the times, specific to date.
THIS LIST IS SUBJECT TO SORTING AND SO THE FORMULA IN COLUMN F MUST USE OFFSET, or a full array to analyse the data and take into account the date.
e.g.
26/10/2009...09:00....13:00
26/10/2009...13:00....13:45
26/10/2009...13:40....16:00 overlap
26/10/2009...15:45....18:00 overlap
26/10/2009...18:15....19:00
27/10/2009...09:15....10:00
27/10/2009...10:00....13:00
27/10/2009...13:00....15:00
27/10/2009...15:00....16:00
Would be an amazing help!!!
Best regards
T