compare time

E

Eddie Munster

I would like to compare a calculated time in my work sheet vs. the actual
system time. For example, if the caculated time is >than or = to the system
time I want excel to tell me to "CALL", if not then "REST"...any help would
be appreciated.

Thanks,
DE
 
G

Gary''s Student

Put your calculated time in a cell (say A1) In B1 put =NOW()
in C1 enter =IF(A1>=B1,"CALL","REST)
 
J

JE McGimpsey

One way:

If your calculated value is in A1, then

=IF(A1>=MOD(NOW(),1),"CALL","REST")
 
J

JE McGimpsey

Student - did you test this?

Your formula should never result in "CALL", since NOW() returns a date
and time, not just a time.

If B1 contains =MOD(NOW(), 1), then the formula would work.
 
G

Gary''s Student

You are right JE. My calculated time was actually a date with time formatting
 
Top