I put in the time function" =now()". How can this automatically update like a
clock does, with recalculating or hitting f9

You will need a recalculation to update the time.

F9 works fine for me.


Gord Dibben MS Excel MVP

On Mon, 25 Dec 2006 10:49:00 -0800, jschlis
wrote:

I put in the time function" =now()". How can this automatically update like a
clock does, with recalculating or hitting f9

Try this "=today()" formula. It will always return the current date
according to the date format of the cell without the need to manually recalc.

"jschlis" wrote:

I put in the time function" =now()". How can this automatically update like a
clock does, with recalculating or hitting f9