Unreal1998
asked on
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
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
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great work!
;-)
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.