Date/Time Concatenate & Compare to NOW()?

[imported_unknown]

I have two seperate cells, one with a date "10/01/02" and the other with a time "=HOUR(TIME(17,0,0))." I am trying to use a conditional statement in a third cell to determine if the NOW() function results is >= to that date and time.

It may be possible for me to change the formatting of each date/time cell to do this but they must remain seperate cells. I can, however, if necessary, concatenate them into a third location. I have been trying this approach, so far, unsuccessfully.

To make it simple, something like:
"=IF((NOW()>=?????),1,0)

I have tried all sorts of concatenate variations and nested/multiple IFs, to no avail.

If anyone has a clue, please help!

Nick/

 

[kskinne]

i believe this formula will return your desired result:

=IF(NOW()<A1,0,IF(HOUR(NOW())<B1,0,1))

if A1 contains your date (10/1/2002) and B1 contains your formula =HOUR(TIME(17,0,0))

HTH
kevin
This message was edited by kskinne on 2002-10-01 16:32