Solved

Excel Timer Clock

Posted on 2010-09-06
3
847 Views
Last Modified: 2012-05-10
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
Comment
Question by:RobertStamm
3 Comments
 
LVL 6

Accepted Solution

by:
Inderjeetjaggi earned 400 total points
ID: 33614287
0
 
LVL 3

Assisted Solution

by:dmitry_n
dmitry_n earned 100 total points
ID: 33616129
0
 

Author Closing Comment

by:RobertStamm
ID: 33811262
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question