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