Countdown timers

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
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,

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
 
Back
Top