Stopwatch- Activities
Feb 2, 2005
I tried out yjoshi's stopwatch, but when I open the stop watch (file was attached in that thread) it is not possible to work with other docs in Excel, and I also have trouble locating the VB code for the actons.
Therefore I am wondering if anyone have any solution on how to get the following:
I was thinking of a button in cell A1 named "Start", when clicked on start time ( date and time) will be inserted in first available column A.
Cell B1 contains a button called "Stop", clicked on will put time in column B and move the marker to cell Dx (x, being row number of the latest stop time.
Why D and not C? In column C I was thinking of a formula calculating the time and in column D I will fill in a short explanation what I did during the time.
View 8 Replies
Jan 2, 2009
Let's suppose that I have a serie of activities. All activities are done in an interval of time and there is not overlapping.
View 14 Replies
View Related
Jun 2, 2003
I need to be able to make an accurate stopwatch in Excel, I want to be able to time a load of Ice Hockey players doing sprints using a laptop on the ice. Excel is perfect cos I can then have a list of players, and just click the button next to the name for them to start..then stop the time. and the Dt is there loaded.
My ultimate goal would be to then modify the code and have have a hardware circuit connected to the parallel port so that the timing could be donw with an external circuit triggering the stopwatch. I'm lookinf for something accurate to hundredths of a second.
Is this possible with Excel and VBA?
View 9 Replies
View Related
Mar 20, 2014
Excel 2010 - I need to create a graph that shows a week's use of a sportsground showing what sports were played, on which days and between which times. I thought I could show the times on the vertical axis, days on the horizontal axis and then the sports played in those times, however I'm unsure as to how to get the graph to recognise the times.
I've attached an example of some data and how I'd like to see it, I'm just not sure how I can do this using the chart set up!
Attached File : Graphs.xlsx
View 10 Replies
View Related
Mar 26, 2014
I have the code below for creating a stopwatch in excel. I was trying to see if there is a way to change this code to assign it to a toggle button so if you hit one part the stopwatch would start and then the other it would stop.
[Code] ....
View 4 Replies
View Related
Jul 31, 2009
I'm looking to have my stopwatch run continuously until "and only until" a command button ("Stop") is clicked. I already have a code and stopwatch in place. I have 5 command buttons: start (starts the timer), call (activates/hyperlinks to another sheet where I have more command buttons and data entry needed/), stop (stops the timer), reset (resets the timer), and record (stamps the elapsed time on the sheet1).
They work great BUT the problem is, when the cell is touched (i.e. when you type a character or double click on any cell even if it's on a different sheet, or even on a different workbook) the timer stops!
I'd think that all this would require just a simple string/line inserted in my code. I'm really, really new to VBA and doesn't know how to write my own codes yet. I have to google what I need every time and do trial and error! Just to give you more info-- I'm using this for a call simulation program, in which the user is an operator taking in a call. She would have to be aware of how much time have passed after performing some actions/data entry on the different sheets on the workbook. I hope I've explained it enough. :D Anyway's here's the code I got, which I think needs just a few edits.
View 10 Replies
View Related
Aug 28, 2007
I have already made a stopwatch function where I can click start and click stop and get the time difference accurate to one-one thusandth of a second, but I need a single cell ( let's say E1 ) to display the continuously changing elapsed time from when I click on my Start button.
View 9 Replies
View Related
Apr 14, 2014
I am trying to create a timekeeping workbook that will track the time I spend on certain tasks. I have created the attached worksheet including macros that correctly allows me switch between tasks but I cannot run this set of macros in one workbook and work in another.
AtTask Timer.xlsm
View 1 Replies
View Related
