+ Reply to Thread
Results 1 to 5 of 5

Creating Multiple Countdown Clocks to specific times

  1. #1
    Registered User
    Join Date
    11-23-2012
    Location
    london, england
    MS-Off Ver
    Excel 2010
    Posts
    2

    Creating Multiple Countdown Clocks to specific times

    Hi.

    I've been unable to find a solution to this on any existing forum (if I'm using the wrong search terms please let me know).

    I wish to create a live timing countdown clock based on a schedule of events so that the current and next events and their respective timings are always visible on screen. It needs to have an easy input for the user to update the schedule.

    For example:

    SCHEDULE OF EVENTS
    Event 1 09:00-10:00
    Event 2 10:00-10:30
    BREAK 10:30-10:45
    Event 3 10:45-11:30
    Event 4 11:30-13:00
    ... [up to 30 events in a day]

    What I would ideally like is an screen (linked to real time on the PC) which shows the [hours:mins:secs] left of current event and the Name and Time of next event (or a mini schedule) below.

    CURRENT EVENT ends in hh:mm:ss

    Next Event: Scheduled Time
    Next Event: Scheduled Time
    etc.

    I know how to use VBA to create simple countdown timers, but don't know how to do it with real time (linked to the PC clock). I also don't know how to create a simple user input for the schedule for laypersons to amend the spreadsheet each time. (they need to be able to quickly adapt the schedule, say if there is an issues and everything gets delayed by 10 mins or there is a schedule change). This is something I will use across multiple time-zones so it will really need to be linked to the automatic date/time of the PC in use.

    Does anyone know of an existing template, or can help me with the VBA?

    Humbly open to all suggestions as this is above my skill level and I've so far failed to find a solution on the web.

    Many thanks

  2. #2
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    2,186

    Re: Creating Multiple Countdown Clocks to specific times

    As a starting point look at one of my previous submissions that may be an aid to code your timer.
    torachan.

    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    2,186

    Re: Creating Multiple Countdown Clocks to specific times

    Also the link below.
    It is an exercise performed by 'Keebellah' of epic proportions.
    There must be ideas within it that would help you formulate an ideal approach.

    http://www.excelforum.com/excel-prog...#post5078348//

  4. #4
    Registered User
    Join Date
    11-23-2012
    Location
    london, england
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Creating Multiple Countdown Clocks to specific times

    Thank you torachan - I've managed to do what I need in the short term by using nested IF statements (horrific) but hopefully I can find a more elegant solution in one of these links. Will update if I find something.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,638

    Re: Creating Multiple Countdown Clocks to specific times

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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. Creating macro to run a model multiple times with different input variables by row
    By notexcellingatexcel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2017, 02:11 PM
  2. [SOLVED] Creating a countdown timer
    By Steve_123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2014, 08:19 AM
  3. Creating a Macro That will Run Solver Multiple Times
    By Otaishtf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2013, 10:28 AM
  4. Creating a basic loop to solve an equation multiple times
    By MechEng84 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2009, 09:26 PM
  5. Creating a numerical countdown
    By timothystow in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-26-2009, 02:41 PM
  6. Creating A countdown timer
    By Vetequk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-31-2008, 06:09 AM
  7. Clocks / Time in excel
    By shug2k3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-15-2005, 07:34 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