Thread: compare time
View Single Post
  #6   Report Post  
Eddie Munster
 
Posts: n/a
Default

Thank you both...works like a charm!!!

"Gary''s Student" wrote:

You are right JE. My calculated time was actually a date with time formatting
--
Gary''s Student


"JE McGimpsey" wrote:

One way:

If your calculated value is in A1, then

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

In article ,
"Eddie Munster" <Eddie 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.