Multiple Timer

Hi guys,
I'm trying to create a file with the ability to record more timers, but I have some difficulties.
This file will be used for sports competitions (for example a cycling race) in which a certain number of athletes (more or less 20 people) start together and arrive at different times.
In my mind this file consists of a single start button (in a cell at the top of the page) and below it several stop buttons (one for each athlete) inserted in different lines with the related end times next to them. No need for pause/resume buttons.

Really appreciate any help you could give me

Hi and welcome to the forum

Does the attached help.

Rather than lots of buttons to stop the time double click an athletes name in row 3.

It uses this sheet Change macro

Please Login or Register  to view this content.

And this macro attached to the biuttons to start the clock.

Please Login or Register  to view this content.

Hi,

See tha variation attached

Hi,

See attached

A double click on the Athlete makes it green. If you've made a mistake a double click again when the athlete cell is green will paint it blue.

My pleasure. Glad to have helped.

Try this one.

It has two decimal places for seconds but if you want just one change the format to "hh:mm:ss.0"

Note that it's a full stop (period) not comma

Hi,

I've used the latest file you uploaded and don't get the error you show.
The difference since the last working version is the use of the VBA Timer command. I'm wondering if your Italian version of Excel recognises this.

Are you able to go into VBA and in the Immediate window enter
Print Timer

It should return a number which is the number of seconds and decimals of a second since midnight.

Actually the requirement to show decimal seconds has not been straighforward. When Excel captures the time by either the user entering the function =TIME() it defaults to (presumably) the nearest second and doesn't contain anything which represents fractions of seconds.

When you asked for decimal seconds it then required use of the Timer VBA function. That allowed the start and stop time to be captured and converted into a string which reflected the decimal seconds. However I had assumed that the Eleapsed time which shows the difference between the start and stop times would reflec the decimal seconds but I've just noticed it doesn't.

I'll need to work out how to work around that.

The first thing to do though is find out why your system won't work. Click then Debug button when the macro halts and let me know which line of VBA code it stops on.

This version now contains decimal seconds in the elapsed time column.

It still uses the TIMER syntax as before and as we don't know why your system failed last time then it's possible this one too will trip up.

I've noticed occasionally that the decimal second elapsed time is 1 decimal second different to the start & stop times recorded. I believe this is probably due to rounding and the very very small time difference that the macro takes to process.

I'm struggling to understand why you encounter a problem.

Would you comment out that row and run the macro to establish whether it is just that row that causes a problem.

If it runs without a problem please refer to this article and check out whether there are any MISSING objects when you select Tools..References in VBA

https://social.msdn.microsoft.com/Fo...forum=exceldev

I'm assuming you have not deleted any of the hidden helper columns on the left?

Originally Posted by Luke78

I've tried on 3 different PCs but... no way... same error..

Do they all have the same Windows 7?
Are you able to check on another Windows version?
What version of Excel are you using?

Did commenting out that row allow the macro to run, albeit without filling in the elapsed time?

Originally Posted by nigelog

I changed my regional settings here to a a few other variants of time and run into no problems on any of them. Can you try that workbook on another pc??

Thanks for chipping in to help Nigel. This is curious.

@Richard
timer runs faultlessly whatever way I format it. I was curious because I was thinking of adapting it for yacht racing


Edit: @ Richard, yes the timer does show that error on Italian region setting. For some reason I checked Spain

@Luke,

It seems that regional settings may be the problem here. Would you temporarily set your Windows regional setting to English(United Kingdom) and the run the macro

@ Luke
I changed it through control Panel > Region and Language > Italian (Italy) - Advanced Settings - Decimal Separator (drop down list choice of two)

This is Office 2016 64bit running on Windows 7 Professional

Hi Luke

See if the attached helps.
There's only one line of code in the Sheet Double Click event procedure that formats the time as a decimal and I've changed that to...

Please Login or Register  to view this content.

Originally Posted by nigelog

@ Richard, first thing I tried. Doesn't help

Mmmm....Thanks Nigel. I'm struggling a bit here..

I'll need to think a bit more...............

Well done Torachan.

Who would have thought that the full stop (period - .) trailing the 'ss' would make all that difference. I've never seen that particular formatting example.

Formula:

Please Login or Register  to view this content.

I've edited my original which contained a similar line of code but without the 'ss.' and jus 'ss' and that seems to work OK as well

Relief all round....

Delete this line from reset macro

Please Login or Register  to view this content.

not in use in this version