Do when a time and date has elapsed

M

Michael

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(b4>today(),"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
 
P

PeterAtherton

Michael said:
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(b4>today(),"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
Click to expand...
Michael

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

regards
Peter
 
B

Bob Phillips

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

=IF(B13+A13<NOW(),"yes","no")


--

HTH

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

Michael

=IF(B13+A13>TODAY(),"yes","no")
Click to expand...

Hi Peter

I tried the above formula but it did not work properly the day was
fine but not the time. I altered your formula slightly TODAY() has
been substituted for NOW(). This now works me thats.

Michael
 
Top