View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Huber57 Huber57 is offline
external usenet poster
 
Posts: 74
Default Continuous Refresh

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