In Excel 2000 - is there any way to set up a cell to repeatedly a.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
About the autocalculate in the status bar... 3
Excel is changing date format incorrectly 7
Cell updates not occuring 11
Copy excel cell to webform (search box) and press enter 10
HELP!!! I can't set formula to cell 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel VBA 1

Back
Top