I think Peter means NOW(), and shouldn't elapsed be ?

=IF(B13+A13NOW(),"yes","no")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"PeterAtherton" wrote in message
...


"Michael" wrote:

I have a problem that is driving me nuts. In cell A1 I have a heading
of Time, and in B1 I have the heading Date. Column A2:A501 is
formatted in hh:mm and B2:B501 is formatted daddy - dd/mmm/yyyy.

I want to use a if statement to if the date in say row 3 and the time
in the same row has elapsed.

I can get the today to work by using =if(b4today(),"yes","no") but
this only gives me from midnight on the day in question, where I need
it from the date and time.

Thanks

Michael

Michael

Is this what you need?
=IF(B13+A13TODAY(),"yes","no")

regards
Peter