Can someone give me a hand with this formula please?
<snip
|
|Assuming times in A1:A2 are to be checked against those in B1:B2
|
|Try in say, A3:
|=IF(OR(AND(A1B1,A1<=B2),AND(A2B1,A2<=B2)),"Conf lict","")
Max. that does it. Of course!
thanks again for your help.
Regards,
H.
|