Ray,
I would like it to refresh constantly. I am trying to build a "countdown
clock" so that is shows me the date and time of an event and then the days,
hours, minutes and seconds until that event happens.
For example:
A1: August 15, 2006 9:00 AM
A2: =(A1-NOW())*24 ---- this would show me hours remaining
A3: =A2*60 --------- this would show me minutes remaining
etc, etc.
When it refreshes constantly, it will show me a countdown.
Doug
"raypayette" wrote:
Usually clicking Tools, Options, Calculations, Automatic recalculates
whe workbook every time a change is made. Do you need something else?
--
raypayette
------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=566221