[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Excel Timer Clock

Posted on 2010-09-06
3
Medium Priority
?
859 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 6

Accepted Solution

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

Assisted Solution

by:dmitry_n
dmitry_n earned 400 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

650 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