On Tue, 8 Nov 2005 10:28:03 +0100, "Niek Otten"
wrote:

|=IF(OR(AND(J3B3,J3<C3),AND(J3E3,J3<F3),AND(J3H 3,J3<I3)),TRUE,FALSE)

Brilliant! Thank you. That worked really well.

At the risk of being a pain, do you know 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.

??
--
Howard Coakley
e-mail... howard<dot}coakleyatcoakley<dot].codotuk
Skype ID: howie10 (get skype from www.skype.com)