Countdown Timer in Excel

Simple Excel countdown timer that includes a Start, Stop and Reset button.

I'll walk you through every step of creating this countdown timer and show you how to adapt it to your needs.

This is a nice little trick, that, though it involves VBA/Macros, is not too difficult to learn and, plus, I walk you through everything you need to do to get it to work.

This tutorial combines a few different features in Excel, including:
- inputting dates and times into cells
- subtracting time from a cell using vba and macros
- counting down using macros in Excel
- scheduling a macro to run
- resetting a timer in Excel

I hope you find this tutorial helpful! Don't forget to download the sample file.

Enjoy!

#excel #vba #timer

[robertovolpi]

It is really amazing!

It supports also the "retour en vol" function like the pilot wristwatches: you can reset and start the timer directly without stopping it first.

[subratadutta]

Really liked the way you explained how the Macro runs. Thank you Sir

[eaglecorps]

Excellent all the way through text plus vid all I needed to get exactly what I was looking for didn't even need to download. thx. Next I'll look for how to add sound at end.

[IvanCortinas_ES]

Congratulations! A great way to execute a Timer! Thank you.

[darrylmorgan]

Really Helpful Tutorial Thank You Sir!

[Fartman]

I also added a large Rounded Rectangle like the button, made it look fancy with a large font, and put =B2 in it for text. It displays the text in the countdown cell.

[bachfor]

Thanks for this tutorial. It has helped me. Any tutorial about how to enable a sound (different beeps, ...) when a button is pushed and, when the countdown reaches endpoint? When it comes to entering into vba I'm a kind of paint-by-numbers person(!)

[gurttron]

OMG was legit looking for something like this! thanks

[reidarnesheim]

Great help here. In some regual meetings we review a predefined excel file, with 10 different sheets. How can I get this timer function to work (be displayed on the active sheet when moving between sheets? If so, we can keep trac of time, regardless where we are in the file. Currently the timer fuction stop when I move to another sheet in the workbook.

[noxvigil]

this is some what help full I'm need one to do like a day loop countdown 21 days with a cell saying on day wat the countdown is and reset after its been completed just need to know if excel must remain open to do this or will it work if closed too

[donovannewton]

If you wanted to record the time from each start, and stop and time complete, can I assign multiple macros to 1 button?

[DarcyWhyte]

excellent example, I really enjoyed that

[Masterblaster]

Great video, thank you. one question, can one "stop" "start" "stop" button control different cells? Thank you

[jabumashjm]

Very insightful. How do I add milli seconds to the timer?

[timohoch]

What if I want to add more than ! Timer? Like one timer in cell A1 another one in A2 and so on?

[RunGord]

This works great, but it causes the whole sheet to recalculate every second. Is there any way to ONLY calculate that cell?

[talanalfouzan]

Thank you for your work but if I want many timers in 1 sheet how would I do it ?

[damirperkovic]

This is fantastic! Although, I am experiencing one issue: If I press the pause button a second time after I've already paused the timer, the whole thing freezes. Is there a line of code I could add to stop this from happening?

[cookiemadoka]

i tried it, and it works. the only thing i want now is to how it will start again over again automatically. for example after "x" time reach 0 it would start again in "x" and do it over and over again. sorry im very new and this is my first "project" im still learning. for reference. i need to check something that resets every 8mins.

[ambipedrigal]

Thanks, for the code however how can i add 'MsgBox "Clock has run out", when time is over? Thank you.