A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Do when a time and date has elapsed



 
 
Thread Tools Display Modes
  #1  
Old April 24th, 2005, 09:17 PM
Michael
external usenet poster
 
Posts: n/a
Default Do when a time and date has elapsed

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

  #2  
Old April 24th, 2005, 10:19 PM
PeterAtherton
external usenet poster
 
Posts: n/a
Default



"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
  #3  
Old April 24th, 2005, 10:42 PM
Bob Phillips
external usenet poster
 
Posts: n/a
Default

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



  #4  
Old April 24th, 2005, 10:46 PM
Michael
external usenet poster
 
Posts: n/a
Default

On Sun, 24 Apr 2005 14:19:04 -0700, "PeterAtherton"
wrote:

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


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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query for 'confirmation' rogge Running & Setting Up Queries 8 April 19th, 2005 03:26 PM
Calendar Question Josh General Discussion 7 March 28th, 2005 11:19 PM
Seemingly (and probably) complex turnaround time rgrantz Running & Setting Up Queries 1 March 21st, 2005 10:19 AM
Aggregating Date Data into Weeks and Quarters Roger Running & Setting Up Queries 3 July 11th, 2004 05:56 PM
Subtracting Time Zone for Universal Time and Date Pal Worksheet Functions 1 February 2nd, 2004 06:04 AM


All times are GMT +1. The time now is 01:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.