Countdown timers
 

Hi All,
I work in a lab and run several tests daily, some
simultaneously. It seems as though Excel would be able to
support one or more countdown timers. I already know how
to refresh a sheet at regular intervals. Does anyone know
of some pre-fab code that allows one to set a certain
value in hh-mm-ss and countdown to 0? I run tests that
range from 5 mins to 24 hours. I have browsed the usual
recommended sites and don't recall any such code.

Mike

Countdown timers
 

No built in countdown timers.

See Chip Pearson's site on using application.Ontime

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy


"Mike" wrote in message
...
Hi All,
I work in a lab and run several tests daily, some
simultaneously. It seems as though Excel would be able to
support one or more countdown timers. I already know how
to refresh a sheet at regular intervals. Does anyone know
of some pre-fab code that allows one to set a certain
value in hh-mm-ss and countdown to 0? I run tests that
range from 5 mins to 24 hours. I have browsed the usual
recommended sites and don't recall any such code.

Mike

Countdown timers
 

Mike,

I have a sample workbook that does this.

Mail me your email address if you want a copy.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mike" wrote in message
...
Hi All,
I work in a lab and run several tests daily, some
simultaneously. It seems as though Excel would be able to
support one or more countdown timers. I already know how
to refresh a sheet at regular intervals. Does anyone know
of some pre-fab code that allows one to set a certain
value in hh-mm-ss and countdown to 0? I run tests that
range from 5 mins to 24 hours. I have browsed the usual
recommended sites and don't recall any such code.

Mike

Countdown timers
 

Mike,

I think you can use the DateDiff & Now function to do the function similar to
countdown.
You can first record the current time by using Now. Then compare the time from
the recorded time by DateDiff.

NC

"Mike" ???
???...
Hi All,
I work in a lab and run several tests daily, some
simultaneously. It seems as though Excel would be able to
support one or more countdown timers. I already know how
to refresh a sheet at regular intervals. Does anyone know
of some pre-fab code that allows one to set a certain
value in hh-mm-ss and countdown to 0? I run tests that
range from 5 mins to 24 hours. I have browsed the usual
recommended sites and don't recall any such code.

Mike