Excel Stop Watch For Time Study

I'm doing a Time Study using an Excel template. I have up-to 5 tabs that will be used to capture time in different sections (tasks). The first tab is unique and it's called Review and tabs 2-5 are duplicates. I don't know if this info matters.

For each section there will be a unique cell that requires a Time entry in format MM and SS( minutes and seconds). I want to have 3 buttons right next to that cell that read “Start”, “Stop” and “Reset”. I know how to create or insert buttons or command buttons. I don’t know which one is best to use.

I'm thinking I need individual code for each button so that it will do the functions on Click. See screen shot of what I want. I will have to repeat the buttons for all all tabs.

Thanks for all your help.



Screenshot.jpg
Unreal1998Asked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
0
 
Jeffrey CoachmanMIS LiasonCommented:
Will you be entering the Reference date manually?

Because if you want it inserted by the "Start" button, then confusion will arise between "Starting" the system (Inserting the Start date) and "Starting" the timer.
0
 
Unreal1998Author Commented:
I'm a bit confused. Perhaps I don't understand your questions well. I don't want to the user to enter the reference time manually. I just want them to hit 1-3 buttons(start. pause, and reset) and whatever time is on the clock(on the cell) is what gets saved for duration.

0
 
Unreal1998Author Commented:
Great work!
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.