Is it possible to have a time running in a cell then to have formula
working off that time

ie in A1 there would be 13:12 that updates every minute in realtime an
when it reached 14:00 that would trigger a formula to give a value etc

Many Thank

--
scottymellot
-----------------------------------------------------------------------
scottymelloty's Profile: http://www.excelforum.com/member.php...nfo&userid=380
View this thread: http://www.excelforum.com/showthread.php?threadid=31447

A clock and more
http://www.cpearson.com/excel/download.htm

--
Don Guillett
SalesAid Software

"scottymelloty" wrote in
message ...

Is it possible to have a time running in a cell then to have formulas
working off that time

ie in A1 there would be 13:12 that updates every minute in realtime and
when it reached 14:00 that would trigger a formula to give a value etc

Many Thanks


--
scottymelloty
------------------------------------------------------------------------
scottymelloty's Profile:
http://www.excelforum.com/member.php...fo&userid=3808
View this thread: http://www.excelforum.com/showthread...hreadid=314471

Thanks Don, its not letting me on the site at the moment, dosnt seem t
be working, i'll try it later, many thanks

--
scottymellot
-----------------------------------------------------------------------
scottymelloty's Profile: http://www.excelforum.com/member.php...nfo&userid=380
View this thread: http://www.excelforum.com/showthread.php?threadid=31447

I have a clock example on my website. Just a line chart using some trig.

You can start the ticking with a button press. It's using API macro
scheduling.



--
Rob van Gelder - http://www.vangelder.co.nz/excel


"scottymelloty" wrote in
message ...

Is it possible to have a time running in a cell then to have formulas
working off that time

ie in A1 there would be 13:12 that updates every minute in realtime and
when it reached 14:00 that would trigger a formula to give a value etc

Many Thanks


--
scottymelloty
------------------------------------------------------------------------
scottymelloty's Profile:
http://www.excelforum.com/member.php...fo&userid=3808
View this thread: http://www.excelforum.com/showthread...hreadid=314471

Thanks i'll have a look at that,

just out of interest does anybody know why on my home computer if i se
the cell to =now() and format the cell to have seconds in it runs as
clock but on my computer at work it just has the time of when i pu
the command in and dosnt update unless i press f2 to refresh over an
over again

--
scottymellot
-----------------------------------------------------------------------
scottymelloty's Profile: http://www.excelforum.com/member.php...nfo&userid=380
View this thread: http://www.excelforum.com/showthread.php?threadid=31447

Right figured out why the =NOW() worked on my home computer, i had th
clock from this site open on another spreadshee
http://www.j-walk.com/ss/excel/files/clockchart.htm and for some reaso
when thats open the =NOW() command in a cell runs as a clock in
seperate spreadshee

--
scottymellot
-----------------------------------------------------------------------
scottymelloty's Profile: http://www.excelforum.com/member.php...nfo&userid=380
View this thread: http://www.excelforum.com/showthread.php?threadid=31447

You may be in Manual Calculation mode.
Check from Tools | Options

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"scottymelloty" wrote in
message ...

Thanks i'll have a look at that,

just out of interest does anybody know why on my home computer if i set
the cell to =now() and format the cell to have seconds in it runs as a
clock but on my computer at work it just has the time of when i put
the command in and dosnt update unless i press f2 to refresh over and
over again.


--
scottymelloty
------------------------------------------------------------------------
scottymelloty's Profile:
http://www.excelforum.com/member.php...fo&userid=3808
View this thread: http://www.excelforum.com/showthread...hreadid=314471