You did nothing wrong...

If you follow the progression of evaluating this formula, you will find
that the first step is to eval 6<6 (time is irrelavent at this point)
which returns TRUE. Then evaluate TRUE11 and the result is TRUE. For
arguments sake, change this to 7<6=FALSE. FALSE11 also returns TRUE.


Hence, your formula returns TRUE. I am not sure why, but Excel treats
both TRUE and FALSE as any number (even a negative).


You may want to break up your comparisons, as such:

=IF(AND(6:00am<6:00am,6:00am11:00am),true,false) returns FALSE

HTH


--
swatsp0p


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