+ Reply to Thread
Results 1 to 3 of 3

Need Multiple Stopwatch Timers on Worksheet

  1. #1
    Registered User
    Join Date
    06-19-2010
    Location
    texas, usa
    MS-Off Ver
    Excel 2010
    Posts
    24

    Need Multiple Stopwatch Timers on Worksheet

    Not sure if this can be done but I need 70 timers on a worksheet. When data is added to a cell, the timer would start. When I highlight this cell or the station number for this cell I would like a message box to open stating the elapsed time and when the cell contents are deleted the timer would reset to 00:00. An alternative to the above would be to have the station numbers in a column on the side with the elapsed time next to it which would always be visible and if the cell is empty the timer would be 00:00. Most of the time at least 60 stations would be active. Is there a limit to the number of active timers running at one time or will this cause havoc with the worksheet? I have attached a simplified worksheet.

    Appreciate any help or any suggestions how to do it better.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-19-2010
    Location
    texas, usa
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Need Multiple Stopwatch Timers on Worksheet

    I think I finally solved it. Instead of using stopwatches, which I couldn't figure how to do, I just subtracted the start time from now(). I would appreciate if someone could look at the formulas etc. to see if what I did makes any sense and if it will work for about 70 stations. Another thing that I would like to do if possible is to have the "Time on Station" always running so that I don't have to keep pressing F9 all the time to update. Any comments on how to do this better will be really appreciated.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-19-2010
    Location
    texas, usa
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Need Multiple Stopwatch Timers on Worksheet

    Any thoughts on this will be appreciated. Could there be a more simplified way than what I have?

+ 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. Best way to make multiple countdown timers
    By Dave_ross in forum Excel General
    Replies: 19
    Last Post: 02-04-2019, 05:06 PM
  2. Multiple Timers within EXcel
    By Janto724 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 04-26-2013, 09:07 AM
  3. multiple countdown timers in excel?
    By hollandrob81 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2013, 04:12 PM
  4. Setup Multiple Timers
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2010, 04:38 PM
  5. Running multiple timers
    By tropy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-17-2006, 09:44 AM

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