Thread
:
compare time
View Single Post
#
3
JE McGimpsey
Posts: n/a
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.
Reply With Quote