Thread: compare time
View Single Post
  #2   Report Post  
Gary''s Student
 
Posts: n/a
Default

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


"Eddie Munster" wrote:

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