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

G

Gareth Evans

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

Gareth
 
M

Manish Bajpai

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
 
P

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)
 
H

Harlan Grove

Gareth Evans wrote...
Is it possible for the Time Function to be live, rather than the time that
the forumla was edited.
Click to expand...

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

Gareth Evans

Harlan Grove said:
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?
Click to expand...

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
 
B

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)
 
R

Ragdyer

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

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