N
Nastech
may seem small enough of a suggestion, was a major problem that did not know
how to ask / never could get a correct answer.
problem: need to be able to figure if input was over "x" hours old, by
date/time in column, from NOW(). using HOUR() in a formula finally figured
out still 59 min off.
guesse was able to ask the right question, got mvp help with..
NOW() help file could use addition to describe use of following:
=IF(24*(NOW()-M9)>1,0,1)
zero is for a false output.. example using
=IF(OR(IF(M9>0,24*(NOW()-M9)>$M$6,TRUE)),0,1)
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...5-accc854a22ad&dg=microsoft.public.excel.misc
how to ask / never could get a correct answer.
problem: need to be able to figure if input was over "x" hours old, by
date/time in column, from NOW(). using HOUR() in a formula finally figured
out still 59 min off.
guesse was able to ask the right question, got mvp help with..
NOW() help file could use addition to describe use of following:
=IF(24*(NOW()-M9)>1,0,1)
zero is for a false output.. example using
=IF(OR(IF(M9>0,24*(NOW()-M9)>$M$6,TRUE)),0,1)
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...5-accc854a22ad&dg=microsoft.public.excel.misc