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.
Microsoft ApplicationsMicrosoft ExcelMicrosoft Office
Last Comment
Bob Stamm
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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