ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Formula =Now() (https://www.excelbanter.com/excel-programming/369842-formula-%3Dnow.html)

Debbie Sheperd

Formula =Now()
 
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

Bob Phillips

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





All times are GMT +1. The time now is 07:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com