Chess timer like utility- built upon some other threads

[dguenther]

Hello all,

I have been researching threads from past Mr. Excel posts and have found some good starting places for my question. I will post the question then post the other relevant threads.

A relatively simple stopwatch function:

Three hot key functions (could be any hotkeys, but I will just use these):

'z' = starts timer 1 and stops timer 2

'/' = starts timer 2 and stops timer 1

'space' = resets both and outputs total time for each timer into it's own column in a new sheet titled "report" in which each row is called something like "trial 1".

That's really about it.

These threads give good starting places, but I am unsure of where to go from them.
http://www.mrexcel.com/forum/showthread.php?t=534628
http://www.mrexcel.com/forum/showthread.php?t=50601


Thanks,
Danny

 

[dguenther]

Oh, and quick thought if there is such a thing as a counter for how many times a
letter is pressed- it would be awesome if it were able to put those counts into separate columns after the time totals.

Thanks,
Danny