PDA

View Full Version : How to check for conflicts in a schedule?



dilipramadas
01-23-2017, 08:50 AM
Hi guys,

I have been working on a formula/function/macro to enable to check for conflicts of time slots? I tried something and I'm pretty sure that it is not correct. Can someone please help on this?



CLASS
BEGIN
END
DAY
STATUS


PMP
900
950
1-Monday



PA
1000
1050
1-Monday



NLP
1100
1150
1-Monday



C
1300
1350
1-Monday



C#
1330
1445
1-Monday







=IF((D2=D:D)="TRUE",(OR(B3=MEDIAN(B3,(B:B):(C:C)),C3=MEDIAN(C3,(B:B):(C:C)))),OR(B3=MEDIAN(B3, (B:B):(C:C)),C3=MEDIAN(C3,(B:B):(C:C))))

I know there might be something to get me the results? Any help is appreciated.
P.S - I'm concerned only about the time slots and day. not the class

Thanks,
Dilip