Bob Stamm
asked on
Excel Timer Clock
Experts,
I am looking to create a Timer clock displaying in an Excel spreadsheet. After a comandbutton is pressed a timer counter needs to start. This will continue to count up until next time command button is pressed. At that point it will reset to zero and start counting up again.
I am looking to create a Timer clock displaying in an Excel spreadsheet. After a comandbutton is pressed a timer counter needs to start. This will continue to count up until next time command button is pressed. At that point it will reset to zero and start counting up again.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dim Start, Finish, TotalTime, FFMinutes
FFMinutes = 0
Start = Timer ' Set start time.
Do While Finish <> 10000000000#
Finish = Timer ' Set end time.
TotalTime = Finish - Start ' Calculate total time.
DoEvents ' Yield to other processes.
If TotalTime >= 59 Then
FFMinutes = FFMinutes + 1
Start = Timer
Worksheets("PickHistory").
TotalTime = 0
Worksheets("PickHistory").
Else
Worksheets("PickHistory").
Worksheets("PickHistory").
End If
Loop