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)
|