Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A stopwatch to record time in a cell
Hi,
I'm new to programming in excel, actually this is the first time. What I'm trying to do is have a worksheet capture the time of a task. I've been able to creat a stopwatch in excel using the following: Option Explicit Private startTime As Single Private Sub StartButton_Click() startTime = Timer End Sub Private Sub StopButton_Click() Dim finalTime As Single finalTime = Timer - startTime MsgBox Format(finalTime, "0.00") End Sub What I want to have is this stopwatch on the worksheet, but to record the time in a cell and then move down to the next cell after resetting. I may not need the stopwatch, but can use the Now() and subtract the times. Can anyone point me in the right direction to do this or possible help me get started? Thank you in advance for your assistance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A stopwatch to record time in a cell
Hi Gabe;
You can use; activecell = Format(finalTime, "0.00") or Range("D1") = Format(finalTime, "0.00") Thanks, Greg -----Original Message----- Hi, I'm new to programming in excel, actually this is the first time. What I'm trying to do is have a worksheet capture the time of a task. I've been able to creat a stopwatch in excel using the following: Option Explicit Private startTime As Single Private Sub StartButton_Click() startTime = Timer End Sub Private Sub StopButton_Click() Dim finalTime As Single finalTime = Timer - startTime MsgBox Format(finalTime, "0.00") End Sub What I want to have is this stopwatch on the worksheet, but to record the time in a cell and then move down to the next cell after resetting. I may not need the stopwatch, but can use the Now() and subtract the times. Can anyone point me in the right direction to do this or possible help me get started? Thank you in advance for your assistance. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A stopwatch to record time in a cell
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
A stopwatch to record time in a cell
Thank you. How or where would I put this into what I alrady have? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Record time by formula | Excel Worksheet Functions | |||
Stopwatch time | Excel Discussion (Misc queries) | |||
How can I get the system date & time for different cell record | Excel Discussion (Misc queries) | |||
how do i format an excel cell for stopwatch times mm:ss? | Excel Discussion (Misc queries) | |||
How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) |