Since NOW() is a volatile function, it will recalculate whenever the
sheet is calculated, so you can use F9 to update it.

Otherwise you'd need to call an OnTime macro to continually recalculate
(or better, put the time directly in the cell).



In article .com,
K1KKKA wrote:

Hi HYCH

Am using the =now() to display time in a cell,


Question = is there anyway to keep it current, other than when a cell
is selected and has data or other info placed into it?


Steve