TIME / NOW Formats

  • Thread starter Thread starter andrewd.wallace
  • Start date Start date
A

andrewd.wallace

Greetings
Does anyone know how to format a cell with the
CURRENT TIME so it updates every second or minute?

Thks

ADWALLACE
UK
 
Andrew

You cannot format a cell to update the time automatically.

You can enter =NOW() in a cell and it will update whenever re-calculation
takes place.

Hit F9 to force a re-calc.

To have a continuously up-dating time would require VBA coding.

For a discussion on this see.........

http://snipurl.com/8cfi

After reading, you will probably abandon the idea.<g>

Gord Dibben Excel MVP
 
Back
Top