Stopwatch with registered timestamp at push of a button

Hi again.

I am trying to find a stopwatch function that register times on a click on a button in a specific cell.
Only thing I find when I am google stopwatch is a start, stop, reset function.

In this case, I want to first reset the timer (If it not only restored allready)
And then, when I push "Start" then stopwatch will start...
Then when I click Reg. 1 the timestamp from the stopwatch is going to be saved to B5
The stopwatch is still going....
Then when I click Reg. 2 the timestamp from the stopwatch is going to be saved to B8
And when I click stop the timestamp from the stopwatch is going to be saved to B11 and the stopwatch is going to stop.

Se attached file...


If there is a more easy way to do this then the example I find, please do tell me...
The file I attached is from google and copy paste with some minor change from me.

Thanks in advance

You don't really need to have a "Stop watch". All you need to do when you "Start" the stop-watch is to record the time it is when you press the button (like in VBA, say:
Range("A1")=Now

When you click on Reg. 1, record the current time in B6
Range("B6")=Now

And clicking Reg. 2 would record current time in B8
Range("B8")=Now

Then you can just do the subtraction to get the elapsed time between the times the buttons were pushed.

I am sorry, but that answer did not help me at all.

I need the stopwatch to be there.
And how do I record the time when I click the button?

I cant excel, thats why I am here.

Please see the attached. Pressing Start clears the times in cells B6, b8, and B10. Press Reg. 1 button, and it shows the time in B6. Reg 2. button then shows time in B8, and Stop shows the time in B10.

Originally Posted by Gregb11

Please see the attached. Pressing Start clears the times in cells B6, b8, and B10. Press Reg. 1 button, and it shows the time in B6. Reg 2. button then shows time in B8, and Stop shows the time in B10.

Thank you, I will look into this when I got some time over.
I will return with answer or more question if needed.

Thanks

Originally Posted by Gregb11

Please see the attached. Pressing Start clears the times in cells B6, b8, and B10. Press Reg. 1 button, and it shows the time in B6. Reg 2. button then shows time in B8, and Stop shows the time in B10.

This looks really good, can it be done so the timer that starts when I press START button would be visible in one cell? Example in A2

I did manage to edit your file to get four diffrent timestamps as I want, but I cant get a timer to be visible when I click start in that file.

Hmm, I thought I replied to this yesterday but it looks like it didn't go through. When you say to have the timer "visible", are you saying you want a cell to show 0:01, then 0:02, 0:03, etc. each second? If so, I googled getting this done and saw a post where you can do that and I was successful in getting that to work, but I couldn't get it to stop. You may have better luck in googling this and getting an answer that works for you. Good luck.

Originally Posted by Gregb11

Hmm, I thought I replied to this yesterday but it looks like it didn't go through. When you say to have the timer "visible", are you saying you want a cell to show 0:01, then 0:02, 0:03, etc. each second? If so, I googled getting this done and saw a post where you can do that and I was successful in getting that to work, but I couldn't get it to stop. You may have better luck in googling this and getting an answer that works for you. Good luck.

Could you please give the link to that, so I could work from there and maybe I find a way to get it to stop.

Originally Posted by bsalv

see attachment with an application.ontime

Wow, thank you so much, that was really helpful to me