Count Down like a digital timer rather than by seconds

[JJFletcher]

Hello All,

I have this code that shows in a worksheet a count down by seconds. I am having difficulty converting it show like a normal digital timer IE: 00:00:00

Any thoughts ???

Please Login or Register  to view this content.

Regards,

John

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

[JJFletcher]

AlphaFrog,

Excellent... thanks so much - works !!!

Regards,

John

[AlphaFrog]

You're welcome. Thanks for the feedback.

Alternatively, you could format the cell A1 as time use this.

Please Login or Register  to view this content.

[JJFletcher]

AlphaFrog,

That works as well... Thanks Again!

Regards,

John

[JJFletcher]

AlphaFrog,

Next task I will tackle is to have the start button create a popup (userform) of the timer and have the start and end buttons on the userform..

Regards,

John

[murphy1969]

Not sure if I should be adding this here. But I would like to continue this thread as I am basing my sheet on this timer.
This is what I am trying to achieve.
The above timer runs continuous 365 days a week. How ever I do want to introduce pauses at
7:00am to 7:10am
9:00am to 9:30am
12:00pm to 12:30pm
3:00pm to 3:10pm
5:30pm to 5:45pm
8:00pm to 8:30pm
11:00pm to 11:10pm
1:30am to 1:45am
4:00am to 4:30am

[torachan]

Another approach to play with.

[murphy1969]

File corrupted error.

[murphy1969]

wow
got home and downloaded the file it worked fine. That sure is a lot of code for a beginer.
Thank you. I will see if I can make some sense of this.

[AlphaFrog]

The above timer runs continuous 365 days a week.

This is the part that stumped me.

[murphy1969]

First of all le me apologize for not returning. I just got this new job and have been working on different projects.
Sorry it should run 365 days.

[AlphaFrog]

You want a countdown clock that starts at 386 days and counts down in 1 second intervals and pauses at the daily times outlined above in post #7? Is that correct?

[murphy1969]

I want 60 min countdown timer say it starts at 7am and keeps looping. Now I want to try and pause it automatically at 9:15am and restart where it left off at 9:30am. I am uploading the excel sheet.