David McRitchie Wrote:
something like the following is invalid in any language
6:00am<6:00am11:00am

David, I assumed the OP was actually using cell references or the like
in their formula, not the actual listed values, and my reply was
written in the same format as the OP's.

My assumption was, e.g.:

A1=6:00AM
B1=11:00AM
C1=6:00AM

=IF(AND(C1<A1,C1B1),true,false) returns FALSE

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=399029