Solved

Excel Stop Watch For Time Study

Posted on 2010-09-10
5
696 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

776 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