I've just seen a new method that I did not know erxisted.

OnTime.

It works quite well but you have to play around with it and I'm not sure for
long periods but havea try with it. See the help pages for information.


--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Martin Fishlock" wrote:

I don't think it is possible to do what you want in real time unless you have
a macro running in the backgroud checking for a change in time and updating
the cell.

But you would not be able to do anything else.


--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Bikertyke" wrote:

Was hoping for a countdown timer in days, hours, minutes and seconds between
now and say midnight on 25 May 2007 (for instance) that will undate on a
second by second basis i.e. permanently countdown and not just refreash when
actioned.