Stopwatch / Timer

I have been looking for a "timer" type script that would:

1. Show current elapsed time since it was started
2. Allow me to work on other parts of my spreadsheet while still keeping track of the time
3. Have a Start/Pause/Stop/Reset capability so I can pause the elapsed time while we take a break or something similar and then press start again and it will continue where it left off (I do not want it to count the time that it was paused in the elapsed time)
4. Once I press Stop give me the ability to "timestamp" a specific field (B4 for example) with the total elapsed time.

Has anyone seen anything like this floating around... I see a lot of discussion about timers but they don't seem to be elapsed timers with an ability to pause.

Thanks for your post Alan. I had also done the Google Search and did look at that particular link. It didn't use start and stop buttons at all, and couldn't be paused and then pickup where it left off, and while it does have a counter it really didn't meet what I needed.

The biggest hurdle I seem to be facing is getting it to run while I use the workbook for other things and the ability to pause it and then start it up again.

Might it be possible to do this with a FORM? Where the form could be up and doing it's timing but I could be using the actual worksheets on the workbook outside of the form?

Thanks for the code. It does as i wanted.

Hello folks,

Ive been looking for a stopwatch program, exactly as desribed on this page. Problem is that I need to call up three stopwatches each with a different title and all able to save data on the same page. Seems that all the code is here but im unsure how to setup the 2nd and 3rd stopwatches. Any ideas?

Thank you so much

thanks, great little bit of code, Jim

Hi, Many thanks - excellent stuff - My need is to launch race cars in a handicap event at our club - my excel sheet calculates the handicap and puts that to a worksheet which lists cars in formup order with the start delay shown as a number, i.e. 5, 9, 14 second delay for cars 2, 3 & 4 on the grid, car 1 starts at 0:00. Your code goes a very long way to helping but I would love to be able to link the counter in your stopwatch to teh cell next to each car's start delay so that the word "GO" appears alongside each car as it's delay start time is reached, with "GO" staying alongside each entry once it has appeared. Start delays run from E:9..E63, calculated by this formula (from E9 on stopwatch worksheet)...=IF(ISNA(VLOOKUP(MATCH($B9,INPUT!$F$11:$F$65,0),INPUT!$A$11:$F$65,5)),"",VLOOKUP(MATCH($B9,INPUT!$F$11:$F$65,0),INPUT!$A$11:$F$65,5)) where "INPUT" is the worksheet that qualifying times are input to. So In the "stopwatch" worksheet I would like to have the word "GO" appear in cells F9..F63 , one by one as the delay in seconds in E9..E63 corresponds to the seconds (and minutes!) on teh stopwatch form. Any ideas would be appreciated.

I am looking for a timer.
These are the specifications..
1. I should be able to set the start time.
2. It should have start pause and reset buttons like this stopwatch.

Thank you for this code as it could help me understand a little more on how to build it.
If you have a similar code available can you please post it.

Thank You in advance.

Hi guys,

I have been designing my Timer as required..but it shows Type mismatch in Show command.

Please Help

Answer Sheet 2 - Testing.xlsm

I have attached a copy of my file

how cai i change this timer to paste the partial time (from timestamp button) always in a new cell, b4, b5,b6....
each time i press timestamp, copy the value to the next free cell

So I created a timer using tigeravatar's code. I modified the timestamp to record time and enter the values into the workbook beginning in a certain row and moving on to the next row for each successive time stamp. I also had it reset the timer to zero after time stamp.

My only issue now is that when i'm using other workbooks, if the timer is running, I can't do the following:

1. open another excel file from outside of excel (e.g. opening a file through windows explorer or trying to open a link from outlook, etc..). I can still use the open file dialog box and open a file that way.. just can't open an excel file outside of excel.
2. the undo button doesn't work anymore. i have other spreadsheets open while the timer is going but the undo/ctrl-z does not seem to work. the undo button is just greyed out.

If I pause the timer or close the stopwatch, then everything works like normal. is this just a limitation of excel or is there a way to fix/workaround this?

Thanks in advance!

Thank you, Thank you, Thank you.