"Howie" wrote:
Actually, it was true/false order. But it was the rest of the
formula which was confusing me!

Thanks for clarifying. Think I crossed the finishing post a little ahead,
but I was misled into running backwards. It's indeed a fine line between
brilliance and obscurity <g

Here's some thoughts on your question:

if there's a way to compare if there is an overlap of a time
period in two different cells? What I mean is, I am
making a timesheet and I want to flag up an error if the times in;
A1(start time), and A2 (end time)
conflict with similar cells elsewhere. Such as:
B1(start time) and B2(end time)

Of course, it's the time BETWEEN the two cells in each set of
times which must not conflict.

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)),"Confl ict","")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

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

You're welcome, Howie !
Thanks for the feedback
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--