The NOW function changes only when the worksheet is calculated or when a
macro that contains the function is run. It is not updated continuously.

Manish Bajpai

"Gareth Evans" wrote:

Is it possible for the Time Function to be live, rather than the time that
the forumla was edited.

Gareth