+ Reply to Thread
Results 1 to 11 of 11

Multiple Timer for Experiment

  1. #1
    Registered User
    Join Date
    06-12-2014
    Posts
    11

    Multiple Timer for Experiment

    Good day. I am here again.

    Is there a way in which I can have multiple time in a single worksheet? This is my situation: I am researching about the effect of a certain substance to my test subject. But the duration is, of course, different from each subject, say, Subject 1 will only for about 15 minutes, Subject 2 for 20 minutes, Subject 3 for 1 hour etc.

    What I want is to have something like this:
    In column A is the Subject, column B is the Duration (in minutes and/or in hours), in column C is the Timer, in column D is the Start button, and lastly in column E is the reset button. My idea is that when the timer approaches the time in column B (which is the duration), the Timer in column C will automatically Stop. In addition, is there a way that after the timer stops, a sound will alert me that the duration for the subject is finished?

    If the above situation is not possible, then it's alright. I just want to know if this can also be done in Excel. Because I do not want to have a very sophisticated gadget just for that. Thank you very much. In addition, I can also use this for other purposes.

    P.S. I'm noob when it came to VBA programming.

  2. #2
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Multiple Timer for Experiment

    Hi there,
    maybe:

    Timer.xlsm

    Try and let me know if this match Your requirements.
    Regards
    Miroslav R.

    (If You like my solutions, feel free to add reputation.)

  3. #3
    Registered User
    Join Date
    06-12-2014
    Posts
    11

    Re: Multiple Timer for Experiment

    Quote Originally Posted by Miroslav R. View Post
    Hi there,
    maybe:

    Attachment 327484

    Try and let me know if this match Your requirements.
    Thank you. But there's a problem I encountered. When I start the time for Subject A, and then start the timer for Subject B, the timer for subject A stops. Is there a way wherein the timer can run simultaneously? In addition (Hehe, sorry, I just really don't know how to do it), in the duration column, I want there to input just the minutes, and the timer will count or count down to something like his: 00:00:01. Example, If I put 00:15:00 in the duration column, the timer will count down to 00:14:59 so on. Can I add subjects in column 1?

    Anyway, your work I really appreciate it. And you got my concept. And it makes me wonder how you can do that.

  4. #4
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Multiple Timer for Experiment

    Hi there,
    so... Have a look at adjusted timer workbook...
    Timer.xlsm

    You can now pick more timers to count (up/down) and add as many subjects as You want.
    If You start first timer, and click again to start new timer, it took about 1 second to pop-up window shows. Also do necessary selections and start as quick as possible, because that is idle time for already started counters. For me, it took max 1,5second, so for every new timer You loss 2,5seconds. I can not imagine how many of them do You want to run simultaneously, but if Your timers are in minutes / hours, I hope those 2,5second wil be no problem for You.
    Already running timers are yellow, finished are green, unless You hit 'Clear' button.
    Turn on Your speakers, and You will know which timer has been finished.

    So I hope You enjoy it.
    (I am going off and in case that new adjustment is needed, I will respond on thursday).

  5. #5
    Registered User
    Join Date
    06-12-2014
    Posts
    11

    Re: Multiple Timer for Experiment

    Quote Originally Posted by Miroslav R. View Post
    Hi there,
    so... Have a look at adjusted timer workbook...
    Attachment 327521

    You can now pick more timers to count (up/down) and add as many subjects as You want.
    If You start first timer, and click again to start new timer, it took about 1 second to pop-up window shows. Also do necessary selections and start as quick as possible, because that is idle time for already started counters. For me, it took max 1,5second, so for every new timer You loss 2,5seconds. I can not imagine how many of them do You want to run simultaneously, but if Your timers are in minutes / hours, I hope those 2,5second wil be no problem for You.
    Already running timers are yellow, finished are green, unless You hit 'Clear' button.
    Turn on Your speakers, and You will know which timer has been finished.

    So I hope You enjoy it.
    (I am going off and in case that new adjustment is needed, I will respond on thursday).
    Thank you very very very much. This is what I need.

    I wanted to run at least 9 simultaneously, because there are three sets, and three subjects per set for the experiment.

    For me it takes 2.5 seconds, but this is not a really big problem.

    Again, thank you. I appreciated your work, really. :D

  6. #6
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Multiple Timer for Experiment

    You are welcome! Happy that it fulfil Your needing! ;-)

    send from my xperia z via tapatalk

  7. #7
    Registered User
    Join Date
    06-12-2014
    Posts
    11

    Re: Multiple Timer for Experiment

    Quote Originally Posted by Miroslav R. View Post
    You are welcome! Happy that it fulfil Your needing! ;-)

    send from my xperia z via tapatalk


    There is one last thing: Is this true to all macro-enabled worksheet that when it is running, you cannot open another excel file and edit that "other" file? Because, I tried this Timer this hour and opens another excel file to input my data. But as long as the timer (macro-enabled) is running, I cannot encode text or insert number or do anything on the opened another excel file. Therefore, I have to wait until the countdown finishes, then do a thing in another file.

  8. #8
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Multiple Timer for Experiment

    Hi,
    Yes - You are right... Unfortunately...
    You can not open&edit another file while the countdown is running.
    I do not know how many data do You want to write&edit in that 'another' file, but You can open&edit e.g. MS Word with some kind of table and after the countdown is finished, You can copy Your data from Word to Excel.

  9. #9
    Registered User
    Join Date
    06-12-2014
    Posts
    11

    Re: Multiple Timer for Experiment

    Hello. Sorry for the late reply. It's alright. I'm just wondering. Anyway, I can do your workaround option. Thanks.

  10. #10
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Multiple Timer for Experiment

    Hi there,
    see modifications in attachement for quick solution:
    Timer.xlsm

    When the countdown reach 0, cell colour turns from yellow to red and the timer keeps counting up. When You want to stom this timer, hit the START/STOP button, pick timer and press STOP. You can stop this way any of the timers.

    Is it something You can work with?

  11. #11
    Registered User
    Join Date
    06-12-2014
    Posts
    11

    Re: Multiple Timer for Experiment

    Good day. I been away for about a month. I'll try your modifications. Greatly appreciated the effort.

+ 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. Design of Experiment add-in/ macro
    By badenpda in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2013, 01:32 PM
  2. Replies: 1
    Last Post: 12-12-2012, 08:46 PM
  3. Design of Experiment for Excel 2003
    By gordonjh in forum Excel General
    Replies: 3
    Last Post: 04-02-2011, 01:23 AM
  4. Feynman Experiment
    By debo2142 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-31-2006, 08:55 PM
  5. I need to create a 7 bubble answer sheet for an experiment.
    By Dolphine1995 in forum Excel General
    Replies: 1
    Last Post: 04-14-2005, 02: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