+ Reply to Thread
Results 1 to 3 of 3

Pause Other Timers when another is Started

Hybrid View

kamalayan Pause Other Timers when... 07-31-2014, 10:56 AM
nathansav Re: Pause Other Timers when... 08-01-2014, 06:38 AM
kamalayan Re: Pause Other Timers when... 08-01-2014, 07:41 AM
  1. #1
    Registered User
    Join Date
    04-22-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    5

    Pause Other Timers when another is Started

    For the lack of appropriate keywords to match searches, i have posted this to seek help.

    I've no VB programming experience. Intended purpose is to create an Excel Time and Motion study.

    I've a set of tasks in Column A which I would like to measure. At times, Users flip from task A to task B then back to A and so on. I would like to be able to pause a timer on task A if when timer on task B is started and same as well with the other tasks.. When Task A is started again, it should continue the timer if not add the on-going time to the presently running time under that task.

    Any help on this is very much appreciated.
    Last edited by kamalayan; 07-31-2014 at 11:02 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Pause Other Timers when another is Started

    When you say timers what are you using the VB timer?
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    04-22-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Pause Other Timers when another is Started

    Nothing in particular, just a function that would run and pause when another one has been triggered active and will continue once the button is clicked again. It will be a set of buttons in-line with each Line item parameter and work(Start-Pause) dependent on the state of other timers.
    Last edited by kamalayan; 08-01-2014 at 07:47 AM.

+ 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. Need nine timers
    By BM28 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2017, 10:15 PM
  2. Timers
    By excelbobabc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2010, 02:22 PM
  3. Using Timers?
    By captainhillman in forum Excel General
    Replies: 2
    Last Post: 10-27-2010, 06:36 PM
  4. Old Timers
    By Mark@Work in forum Excel General
    Replies: 2
    Last Post: 12-01-2006, 05:05 PM
  5. [SOLVED] 2 Timers
    By Al in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-13-2005, 04:06 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