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)
Nastech - 27 May 2008 09:49 GMT
p.s. M9 has NOW() entered in it, such as: 2008-05-27 9:00:00 AM
> may seem small enough of a suggestion, was a major problem that did not know
> how to ask / never could get a correct answer.
[quoted text clipped - 19 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=728e09d6-8b7e-4
f8e-8135-accc854a22ad&dg=microsoft.public.excel.misc