| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In Excel 2000 - is there any way to set up a cell to repeatedly a.
WOuld like to display a function giving time left until a set time. This
would probably use NOW() and a date/time cell. Subtracting the two gives time remaining. I would like to have the cells autocalculate so that this displays as a countdown clock. Any idea how to do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
In Excel 2000 - is there any way to set up a cell to repeatedly a.
The formula
=A1-NOW() gives the time left, but it doesn't recalculate unless I press F9. To get this to work, you probably need a static value in the cell and an OnTime macro that updates it. The performance hit could be considerable if it's to update every second. On Tue, 12 Oct 2004 16:49:05 -0700, tj7978 wrote: WOuld like to display a function giving time left until a set time. This would probably use NOW() and a date/time cell. Subtracting the two gives time remaining. I would like to have the cells autocalculate so that this displays as a countdown clock. Any idea how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make text in Excel repeatedly flash on and off? | Excel Discussion (Misc queries) | |||
| Excel 2002: How to speed fill repeatedly ? | Excel Discussion (Misc queries) | |||
| Print a worksheet repeatedly with each list cell | Excel Discussion (Misc queries) | |||
| I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
| Excel Crashes Repeatedly | Excel Discussion (Misc queries) | |||
Linear Mode
