Clock in Excel?

[RodneyW]

Is there a way to add a clock, or timer to a spread sheet? Really what I need is a "stop watch" type function that will track and record a relay race over a 30 to 40 hour period. I need to be able to click a cell (or actually take some sort of action) and have it start the timer, then when clicked again, record the time from the original start to the second click and report it in a cell. The stop watch needs to continue running and when clicked a third time, enter the time between the second click and the third, record it in a cell as well as record the total time in another cell. This needs to continue until 36 legs of the relay have taken place.

Is this even possible in Excel? I'm also looking in to Flash for a solution.

Thanks

 

[hiker95]

RodneyW,

See:

Create a StopWatch in Excel
http://vbaexpress.com/kb/getarticle.php?kb_id=242

 

[VoG]

Also http://www.mrexcel.com/forum/showthread.php?t=534628

 

[RodneyW]

Hiker,

Thanks. This is a start but doesn't quite do what I need. I'll keep searching.

 

[RodneyW]

This link: http://orlando.mvps.org/ExcelStopwatchMore.asp
provided a solution that should work fine. Not perfect, but close enough for what I want to do.

Thanks