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

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

Gareth

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

"Gareth Evans" wrote:

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

Gareth

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)


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

Gareth

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?

"Harlan Grove" wrote in message
ups.com...
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?

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

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)


"Gareth Evans" wrote in message
...
"Harlan Grove" wrote in message
ups.com...
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?

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

See

Countdown Timer
http://www.tushar-mehta.com/excel/so...own/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

In article ,
says...
"Harlan Grove" wrote in message
ups.com...
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?

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

Peo,
What's <Alt <F9 ?

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peo Sjoblom" wrote in message
...
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)


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

Gareth