+ Reply to Thread
Results 1 to 6 of 6

Problem adding more countdown timers

Hybrid View

jdublya Problem adding more countdown... 03-05-2014, 06:09 AM
LJMetzger Re: Problem adding more... 03-05-2014, 08:25 AM
jdublya Re: Problem adding more... 03-06-2014, 08:14 AM
LJMetzger Re: Problem adding more... 03-08-2014, 02:46 PM
jdublya Re: Problem adding more... 03-10-2014, 05:14 AM
LJMetzger Re: Problem adding more... 03-10-2014, 11:56 AM
  1. #1
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Problem adding more countdown timers

    I haven't looked at your code, but I think you are taking the wrong approach. You probably only need one timer. I would use the following algorithm:
    1. Start the time of day timer either from Workbook_Open() or manually through a command button.
    2. 'Click' on a command button for Exam 1. Associated with Exam 1 is an Exam duration (source unknown). Save the date and time when the command button was clicked.
    3. Repeat step 2 for all other exams whenever they start.
    4. In the timer event handler code, you perform the calculations and display the elapsed time and time remaining for each Exam as required.

    The file from Post number 2 in the following link takes a similar approach to a different problem.
    http://www.excelforum.com/excel-prog...ain-value.html

    I'm very busy the next couple of days, but if you still need help on Friday, I can probably come up with a solution by Friday afternoon.

    Lewis

  2. #2
    Registered User
    Join Date
    03-04-2014
    Location
    wales
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Problem adding more countdown timers

    Hi Lewis,

    Thanks for answering this.

    The exam duration is automatically brought into the front sheet as a Vlookup from an examination details sheet with the entry generated by the subject/paper chosen from a drop down list on the front page.

    The exam invigilator would then press the start button for that exam when it commences. There may be a number or exams starting at the same time, but for different durations, however this is not a problem as the current set up allows the user to select up to 5 different subjects/papers and the durations for each are individually generated.

    My problem is if the invigilator then want to start another subject/paper at a later time ie when the first exam(s) have already started. As it currently stands, this is the concept I am having trouble with. Whilst I think this may be what you have solved in your reply, sorry but I don't grasp what it is you are suggesting I do to resolve it. Sorry to be slow on the uptake, but I think my brain is getting tired and becoming "reptilian" in functionality ie seriously lacking!

    Thanks again for your time and trouble in replying.

    Kind regards
    John

+ 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 Countdown timers.
    By dawidski in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2013, 11:42 PM
  3. How to Create Mutiple Countdown Timers In Excel
    By Janto724 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2013, 06:36 PM
  4. multiple countdown timers in excel?
    By hollandrob81 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2013, 04:12 PM
  5. Countdown Timers?
    By phil2006 in forum Excel General
    Replies: 2
    Last Post: 09-11-2007, 07:00 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