• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 867
  • Last Modified:

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.
0
RobertStamm
Asked:
RobertStamm
2 Solutions
 
InderjeetjaggiCommented:
0
 
dmitry_nCommented:
0
 
RobertStammAuthor 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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now