Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NOW() help in xl could use some
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(M90,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/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
NOW() help in xl could use some
p.s. M9 has NOW() entered in it, such as: 2008-05-27 9:00:00 AM
"Nastech" wrote: 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(M90,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/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|