The Time

[adn4n]

Hi there,

I have the time formula which is =now()
but once this is typed into the formula bar, and ok is clicked then th
time doesn't move in 'realtime'. It is often updated when i click i
and out to edit cells.

I wanted it to be so that i can see the seconds moving for the time s
that i know it is alive, is there any possible way that this could b
done. I have seen it before.

Regards

 

[Frank Kabel]

Hi
have a look at the following site (scroll to the bottom):
http://www.mvps.org/dmcritchie/excel/datetime.htm

There're some stop timer macros (can't be done with formulas alone)

 

[Anne Troy]

See if this helps: http://www.cpearson.com/excel/ontime.htm
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->