PDA

View Full Version : Countdown timer



Mykasd
04-10-2008, 09:46 AM
Is there a way to make a countdown live? That is, can you make the cell tick down the seconds in real time? If cell A1 has days, A2 has hours, A3 has minutes and A4 has seconds....I'd like to be able to see the numbers actually moving in real time, is that possible?

mdmackillop
04-10-2008, 10:00 AM
How about this (http://www.xldynamic.com/source/xld.XtraTime.html)?

Mykasd
04-10-2008, 11:13 AM
It is only a few cells. One for days, another for hours (days cel * 24), another for minutes (hours cell * 60) and one more for seconds (minutes cell * 60)

Bob Phillips
04-10-2008, 12:10 PM
Did you check the link?

Mykasd
04-10-2008, 02:10 PM
I am not able to download that workbook. Any way someone could provide the code in text?

Bob Phillips
04-10-2008, 02:53 PM
Tell us why you couldn't download it and we can help you. I belive it is quite a lot of code as I recall.

Mykasd
04-11-2008, 07:45 AM
This code is very hard to manipulate, especially since it ticks up and not down. I have the cells calculated off of each other (different cell for seconds, minutes, hours and days). But want each to count down accordingly: seconds count down every second and so on...Any suggestions?

Bob Phillips
04-11-2008, 08:31 AM
That is a bit different from not being able to downlkoad, and whilst I disagree that the code is hard to manipulatre (it is extremely well-written <g>), here is a simpler version

Mykasd
04-11-2008, 11:05 AM
Sorry I guess I am a bit of a VBA novice. However, xld you make things very easy. Code worked flawlessly, thank you.

Oakbumbs23
04-12-2008, 05:06 PM
Interesting.. always confused on the timer