now function
On 22 jun, 10:04, "Richard" <nomailplease.com wrote:
I got a cell A1 with a now function =now() which gives the current time.
Cell A2 has a time that is entered, and cell A3 has an if function that
compared if(A1A2,"","Do Something"). However, the if statement is true all
the time even if the time is cell A2 is a later time than A1. I changed the
format in cell A1 from a time format to a general and it turn out to be a
big number. Otherwise, I changed the time format in cell A2 into general
and it is a very small decimal number. How do I get around this, may with a
mod function or something?
This is a bit cumbersome, but it works ok. Press the F9 key at any
time to update the time displayed in C1
A1 =HOUR(NOW())
B1 =MINUTE(NOW())
C1 =TIME(A1;B1;0)
A2 Hour entered by operator (0 - 23)
B2 Minute entered by operator (0 - 59)
C2 =TIME(A2;B2;0)
A3 =IF(C2C1;"Later";"Earlier")
|