Countdown clock in Excel

My work buddy Jurre is drastically changing his career path for the better by relocating to Ireland this week. To help him keep track of the time he has left in his current job I made him a countdown clock in Excel. It shows the number of days, hours, minutes and seconds left both in separate cells of a sheet and in the titlebar of the Excel window. It demonstrates the use of the scarcely documented Excel function DATEDIF and the Application.OnTime method to update the clock at one second intervals. The workbook you can download here counts down to the new year 2010, but you can easily change the date and time it counts down to.

14 thoughts on “Countdown clock in Excel

  1. hello!
    I’ve been searching for a countdown clock just like this one all over internet! So happy I found this here!Thank you! But one question, is it possible to insert it in a Powerpointpresentation? Tried it but I can’t get it to work. Serching for tutorials too but no luck. do you have a solution?
    Big thanks again for sharing!
    🙂

  2. Hi Pia,
    Thanks for the feedback 🙂 I’m afraid I haven’t got an easy solution to your problem. I also tried to embed the countdown Excel workbook into a Powerpoint presentation, but didn’t succeed. Although one can easily insert Excel worksheets into a presentation slide, it seems that only a static view of the data in the Excel sheet is shown. In other words, the countdown clock doesn’t update itself.

  3. Hi Aswin,

    Thanks for your quick reply. I solved my problem with a flash countdownclock, made one from this tutorial:
    http://www.republicofcode.com/tutorials/flash/video/countdown.php

    and found this little nice add-in for Powerpoint that makes it very easy to insert flash .swf files into Powerpoint: http://www.ispringsolutions.com/products/ispring_free.html

    So, if you’re into Flash maybe this is something for you too.
    But I will save your nice excelclock, it will come inhandy in the future! 🙂
    Kind regards
    //Pia

  4. Hi David,

    I’m not entirely sure what you mean by “make this work in reverse”, but I assume you want the excel sheet to show the time that has passed since a certain date.

    If this is what you want, then the answer is very simple. You have to swap the contents of the cells B1 and B2, so that B1 contains the function =NOW() and B2 contains the date (in the past). You’d have to unhide row 2 first.

    Hope this helps.

  5. I am attempting to count the days, hours, min, sec’s from and event that occurred at work. A “Count Up” clock per say, thank you.

  6. Hello,
    I would appreciate your help if possible. Is there a way for me to include a countdown timer for each new row (or every other row) in an excel spreadsheet? My purpose is to create a “flight log” for my R/C Helicopters and batteries. What I would like to do is simply hit a start “button” of some sort then have the spread sheet start with the current date and time then count down from a certain period (depends on the battery)like 5 minuets, give me an alarm, then stop when I hit the “button” and finally, log the time in minuets that were actually flown?

    Any help is greatly appreciated!

    Cheers,
    David

  7. Love it!! One (hopefully small) ammendment I coulkd do with.
    Would like instead of the countdown in Days – hours- etc.

    Weeks – Days – etc

    Is this possible?
    Respect
    Nigel

  8. Thank you so much for making this available. I am using it to track how much time until our VBS starts! It works awesome!!

  9. This works great, but if the end date hasn’t been reached i excel loops and reopens. What do i need to add to the marco to stop the looping?

  10. this looks very classy (looks like a widget).
    Does not work on excel 2011 for Mac, Compile error can’t assign to read-only property for module containing “Public Sub OnTimerFunc()”…
    Any clue?

  11. Hi Cyrilbrd,
    I don’t know why this doesn’t work on a Mac. I know there are some differences between the Excel object model for Windows and the one for Mac, but I don’t know which difference is causing the compile error. I don’t own a Mac otherwise I could test this code myself.

Leave a Reply

Your email address will not be published. Required fields are marked *