Implementing a Stopwatch in Excel...

[traversd]

Can anyone help me with a little project I've dreamed up ?

I need to be able to make an accurate stopwatch in Excel, I want to be able to time a load of Ice Hockey players doing sprints using a laptop on the ice. Excel is perfect cos I can then have a list of players, and just click the button next to the name for them to start..then stop the time. and the Dt is there loaded.

My ultimate goal would be to then modify the code and have have a hardware circuit connected to the parallel port so that the timing could be donw with an external circuit triggering the stopwatch. I'm lookinf for something accurate to hundredths of a second.

Is this possible with Excel and VBA ? Can anyone help start me off ?

Cheers
Darren

 

[tusharm]

HOWTO: Use QueryPerformanceCounter to Time Code
{snip of unformatted dump of MS article}
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q172338

I'm sure you meant well, but a reference to the article would suffice. There's no need for an unformatted dump of the contents, is there?

 

[traversd]

Wow Some right answers in there !

For my initial purposes Tusharm's small piece of code is perfect.

I can have my list of players and time them all sequentially using the 1 and TAB method.

It might not be the same for the running example, but for the present my Timings don't need to be super accurate, I am looking for a tool to baseline the performace of my team and record improvement. As long as it can give a reasonably accurate time with a couple tenths of a second.

Mind you if they improve sunstantially, those tenths are going to need to be acccurate !!

Thanks to all. ary:

Regards
Darren

 

[harry_thorne]

hi,
I am having trouble getting these codes to work. sometimes it is the dubugger and sometimes nothing happens. Would someone be able to email me a worksheet with the code inputted as I fear it is my ineptitude that is preventing them from working,
cheers
Harry

 

[tusharm]

Don't type in the code yourself. Just copy it from the web site and paste it into the appropriate VBA module.

 

[dmitry_n]

This timer might help.

 

[Askeeta1]

Tusharm,
Could a cell be set to start timer tapping cell on a touch screen tablet, iOS or Windows
Rows 1,2,3,not in the formula
Column A, Process being timed,(unlimited possible processes)
Column B, Time (stopwatch) elapsed time,format whole seconds,no decimals,tap cell to start,tap cell to stop,double tap reset
Column C, Yes/No
Column D, =if(C4=FALSE,B4,0)
Thankyou