Beautiful! Works great. Thanks Biff!!!

Frank

On Sat, 25 Nov 2006 00:01:04 -0500, "T. Valko"
wrote:

Try this:

=IF(J2="","",IF(MOD(J2,1)<TIME(15,30,0),"Yes","No "))

Biff

"Phrank" wrote in message
.. .
Hello,

I posted a question a couple days ago, and although it seemed that
things were working ok, they weren't. I've got a date/time stamp IN
in column A, and a date/time stamp OUT in column B. I need column C
to say Yes if the time OUT is less than 3:30 PM, and NO if the time
out is after 3:30 PM. The format in both the IN and the OUT columns
is 'mm/dd/yy h:mm AM/PM' (e.g., 11/24/06 9:39 AM). Below are the two
formulas that I have tried:

=IF(J2="","",IF(J2<="3:30 PM","Yes","No"))
=IF(J2="","",IF(J2<TIMEVALUE("3:30 PM"),"yes","no"))

What adjustments do I need to make to this? Thanks for any help.

Frank