Cross Country Timing/Recording Issues

Hi there,

Needing some help with a spreadsheet which is principally designed to record Cross Country runners and tally up the points. I have attempted to integrate a timing feature into the Spreadsheet which by the user clicks on one button in the Score sheet which then records the time at the time of the click (when the race starts). Then as runners cross the line, another button is clicked to record the time they finished and then calculates their finishing time based on the start time and time when the button is clicked. I've copied the code from another spreadsheet but I think I have messed it up as the finishing time ends up in the wrong place. Can I please get some assistance in fixing it. I also would like to use a "hotkey" such as the Caps Lock key on the keyboard to make it easier than having to click on the button each time. I'm quite a noob when it comes to VBA and Macros so I would very much appreciate the help.

NOTE: I'm having trouble attaching it as it is 1.29MB which is to big to attach here. I don't know how else to get it to you to have a look at? Direct email??

Please ask any questions you may need to clarify the problem.

Thanks!!

EDIT: Posted elsewhere https://www.mrexcel.com/board/thread...acros.1166529/

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

You don't need to delete it. You DO need to post a link to it.

Possibly so... or not. But I, for one, have only just seen that you have provided the link. Had you replied saying"done", I would have seen it hours ago.

Members, feel free to help.

VBA solution - no onsheet formula - for anybody that is interested as OP has not replied so result pages are guesswork but results are there.
Competetitors are entered on list then transfered to 'Timing' sheet prior to event start.
After transfer of competitors to 'Timing' next press 'Reset' to prepare for start, Press 'StartTimer', to record finishers 'double click' on white bib numbers.
After end of event transfer the timings to the result pages.
torachan.

p.s. the app is elastic - i.e. put as many competitors in as you wish everything should expand/contract to suit (present max 60 - just alter the page scroll area if you want more)