Timer with milliseconds and Automatic data transfer from sheet to sheet

handstopped timers have an accuracy of min 0.1 sec for experienced people, 0.5 for others, so why calculate in millisecondes ?

Can you upload an example, now it's fuzzy.

Unfortunatelly no for some reason the "Attachments" and "Insert Image" buttons are not working for me

Edit: I tried to post a link and got this message: "You are not allowed to post any kinds of links, images or videos until you post a few times." So... i can answer questions tho

I did that, i uploaded the file there, but i still can't attach it here. When i press the "attachments" button i get a blank line

I can't remember but I created a macro based on system timer as well, which would alt tab and copy automatically to Excel as I was a lazy piece of sh*t who didn't like manual entry. Got fired from the job as they had less to charge their clients. The below can be moulded to your needs.

You are looking for something with timer function as in example from VBA documentation:

Please Login or Register  to view this content.

A millisecond is 10^-6, so just put it in decimals and you should be fine. This code was found https://docs.microsoft.com/en-us/off...timer-function

it was also my idea to use that timer and there are also questions about it's accurancy.
https://bytecomb.com/accurate-perfor...timers-in-vba/
You are using an old 2007, you are just fooling yourself if you use an accurancy < 0.1 sec.

these days even the timers in smartphones have an accuracy of .01

The smartphone is ok, the human finger isn't.

But the question is "what is to be measured".
The total time or laps or ... in a race over 5, 10 or 40 km ?
So still waiting for the attachment to get a better idea

Originally Posted by bsalv

You are using an old 2007, ...

The 2007 version is temporery, thanks for the link, i'll check it out. What is to be measured is total time for each athlete individually.

what i do is having a commandbutton with now function locked

Please Login or Register  to view this content.

and when i press it to, lets say, A1 it shows the current time in this costum format "16:33:43.87" when the athlete finish the race i go to B1 and press it again so i have the finish time "17:23:43.04" and then do a substraction B1-A1 and get his total time of the race. BUT in order for this to work and not update the now() funcion every time i make a change somewhere else is to disable autocalculation through the workbook and use macros to just refresh certain sheets when i wish, where i keep the results, so my formulas and vba codes autosorting the winners based on their time, and some other things to be shown properly. It works.

I found timers that work as well, and i can keep the autocalculation on, but can't get the milliseconds which is not something i can give up. Even if my human finger is not that fast there is a demand for that accuracy.

I can't attach anything. I'm going to manage attachments, i upload the file there, but when i'm pressing the attach button in the reply window nothing is showing up, when i return to manage attachments the file is gone

You will need workbook_close event, essentially that is what you need. But be wary that workbooks need to be macro enabled and trusted.

see attachment, chrono for x players.
- push start button
- click with the right mouse key on the name of the player to stop its chrono
- when all players are arrived, click on the "transfer" button.

short example to give you an idea

One from the depths of my archives.
Designed initially as a schools cross-country run timer.
Competitors list is first populated then transfered to the 'timing sheet'.
Mass start at the click of a button - individual finishers double-click 'bib' number.
Result sheets produced when end of race is confirmed.

I can't attach anything. I'm going to manage attachments, i upload the file there, but when i'm pressing the attach button in the reply window nothing is showing up, when i return to manage attachments the file is gone

You are missing a step - are you clicking the button on the right to upload the file and then the save button?

Go Advanced | Manage Attachments | Browse to file ... | Upload (across on the right) | Close this Window (also across on the right) | Submit Reply.

You must be missing at least one of these steps.