Current Time Formula

[ADE2]

Hi

Is there a formula to show the current time in a cell that update
every second as the computers clock does,even if there are no change
to the spreadsheet

Thanks

Ad

 

[Jason Morin]

This really isn't recommended because it'll slow XL's
processing ability greatly. Nevertheless, Ingrid Baplue
posted some code on how to do this:

http://tinyurl.com/yvzs5

HTH
Jason
Atlanta, GA

 

[skitek]

check this out:
type in a cell
=now(

 

[ADE2]

Thanks Jason,i think i'll forget about it,don't want to overload m
computer

Ad