=NOW() Time Function. I want this to be live!

[Gareth Evans]

Is it possible for the Time Function to be live, rather than the time that
the forumla was edited.

Gareth

 

[Guest]

The NOW function changes only when the worksheet is calculated or when a
macro that contains the function is run. It is not updated continuously.

Manish Bajpai

 

[Peo Sjoblom]

It is "live", you need to re-calculate the sheet for it to update (F9 or alt
+ F9)

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Harlan Grove]

Gareth Evans wrote...

Is it possible for the Time Function to be live, rather than the time that
the forumla was edited.

It is live to the extent it'll recalculate upon any recalculation in
addition to reentry. If you mean you want a cell to keep ticking away,
showing the current time when there's no user intervention whatsoever,
it can be done, but in spreadsheets IT'S A **VERY** BAD IDEA. Why?
Because it requires running a macro that repeatedly calls itself using
the Application.OnTime method, and that makes not only Excel but the
whole system SLOW.

Since users can choose to display a clock in their task bar, why do you
believe you need to provide a redundant clock in your workbook?

 

[Gareth Evans]

Gareth Evans wrote...

It is live to the extent it'll recalculate upon any recalculation in
addition to reentry. If you mean you want a cell to keep ticking away,
showing the current time when there's no user intervention whatsoever,
it can be done, but in spreadsheets IT'S A **VERY** BAD IDEA. Why?
Because it requires running a macro that repeatedly calls itself using
the Application.OnTime method, and that makes not only Excel but the
whole system SLOW.

Since users can choose to display a clock in their task bar, why do you
believe you need to provide a redundant clock in your workbook?

I wanted to create a program that showed the minutes and seconds left to a
deadline. Though for this job it would probably be better to create a small
program, rather than use a spreadsheet.

It was out of curiousity really.

Thanks for your reply.

Gareth

 

[Bob Phillips]

If you want it it can be done with a Windows Timer, not tying up the app as
Harlan says.

Still want it, it's a lot of code?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Tushar Mehta]

See

Countdown Timer
http://www.tushar-mehta.com/excel/software/countdown/index.html

VBA Timer object for developers (beta version)
http://www.tushar-mehta.com/excel/software/vba_timer/

and a simple way to generate a metronome in
Excel Dynamic Formatting
http://www.tmehta.com/tmxl/dbfind_byid.asp?id=14

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Ragdyer]

Peo,
What's <Alt> <F9> ?

<Alt>
*Then*
<F9>
Toggles the <F9> off from triggering calculation when in manual mode!