Solved

Excel Stop Watch For Time Study

Posted on 2010-09-10
5
694 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:Unreal1998
  • 3
  • 2
5 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33648114
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
 

Author Comment

by:Unreal1998
ID: 33648196
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
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 33648243
0
 

Author Closing Comment

by:Unreal1998
ID: 33648781
Great work!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33649159
;-)
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now