Stopwatch/Clock
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?
|