+ Reply to Thread
Results 1 to 2 of 2

Excel stopwatch

Hybrid View

buwa84 Excel stopwatch 07-17-2015, 11:10 AM
buwa84 Re: Excel stopwatch 07-17-2015, 11:12 AM
  1. #1
    Registered User
    Join Date
    05-09-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    56

    Excel stopwatch

    I need to time a process at work. Rather than sitting next to the individual i want to give them spreadsheet with Start and Stop buttons and another column to enter comments.

    Click of the start button would start the clock and the stop botton would stop the watch and enter the time A2 and reset the clock.

    Thanks

  2. #2
    Registered User
    Join Date
    05-09-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    56

    Re: Excel stopwatch

    This what i have so far. But dont know how to code to enter the results in the spreadsheet and how to reset the clock..

    Private Sub Rectangle1_Click()
    
        startTime = Timer
    End Sub
    
    Private Sub Rectangle2_Click()
     
        Dim finalTime As Single
        finalTime = Timer - startTime
        MsgBox Format(finalTime, "hh:mm:ss")
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel Stopwatch Help [VBA]
    By lilhugo in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-05-2013, 10:27 AM
  2. Creating a Stopwatch in Excel.
    By Learning_XL in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-05-2011, 10:18 AM
  3. Excel Stopwatch
    By daddy_smo in forum Excel General
    Replies: 2
    Last Post: 07-26-2011, 02:22 PM
  4. Excel StopWatch
    By roy.furman@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2006, 08:05 AM
  5. Is it possible to place a stopwatch in Excel
    By Kari in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  6. Is it possible to place a stopwatch in Excel
    By Kari in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  7. Is it possible to place a stopwatch in Excel
    By Kari in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1