PDA

View Full Version : Stopwatch in Excel



somebody
29-03-2003, 01:49 PM
I've been asked to design a program for recording results from a triathlon.

I was wondering if there is a way to add a stopwatch function to MS Excel, and if so, how it can be done. I will need to be able to click a button and have it record a time for a particular participant.

godfather
29-03-2003, 03:13 PM
try playing around with

=NOW()

this will return the PC date and time, by formatting the cell you can get to hubdreths of a second.

somebody
29-03-2003, 03:38 PM
ok. Thanks godfather

Russell D
29-03-2003, 06:10 PM
Be aware that the =NOW() function will update each time the worksheet is recalculated.
Whereas if the VB function NOW is run, it will place that fixed time in the worksheet.
If you have two buttons, one for "Start" and it enters NOW in a cell, another button can be for "Finish" and if each time the button is pressed it enters NOW - Starttime, you will get total elapsed time for each entrant.
These cells will require Custom formatting to hh:mm:ss.

somebody
30-03-2003, 09:14 AM
Ok. Thanks Russell. Now I have go to and hunt down help on VB.

Luckily I don't have to have this "program" completed until this time next year, so I have plenty of time to learn :)