Thread: Stopwatch/Clock
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Easty Easty is offline
external usenet poster
 
Posts: 2
Default 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?