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
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