Thread: compare time
View Single Post
  #4   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.

In article ,
Gary''s Student wrote:

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