Check out John Walkenbauch's utility:

http://j-walk.com/ss/excel/files/clockchart.htm

Regards,
Greg


-----Original Message-----
I want to display the time in a worksheet but want it to
update automatically like a clock.

It is to be used like a clock at a football game - any
ideas.

I have done it by using a macro to paste the time the
game starts in a cell and then use Now()-start time to
give elapsed time.

I then have a macro to f9

I'm sure it can be done automaticly every second but
don't know how.

Any ideas?
.