Thread: Formula =Now()
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Formula =Now()

See other post.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Debbie Sheperd" wrote in message
...
Hello;

In a worksheet single cell I have the formula =NOW(). I need that to run

&
show time constantly. However, sometimes it just stops at a certian time

and
won't refresh until some other action happens on the worksheet. Any
suggestions on how I can have the time (h,m,s) show in a cell on constant
basis?

Debbie