|
Running Clock
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 |
Running Clock
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 |
Running Clock
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 |
Running Clock
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 |
Running Clock
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 |
Running Clock
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 |
| All times are GMT +1. The time now is 11:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com