Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Excel Stop Watch For Time Study

Posted on 2010-09-10
5
Medium Priority
?
734 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 2000 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

580 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