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.
Bob StammOperations ManagerAsked:
Who is Participating?
 
InderjeetjaggiConnect With a Mentor Commented:
0
 
dmitry_nConnect With a Mentor Commented:
0
 
Bob StammOperations ManagerAuthor Commented:
Vaild solution but i took different approach.

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").Range("l1") = FFMinutes
            TotalTime = 0
            Worksheets("PickHistory").Range("m1") = TotalTime
        Else
            Worksheets("PickHistory").Range("l1") = FFMinutes
            Worksheets("PickHistory").Range("m1") = TotalTime
        End If

    Loop
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.