TIME / NOW Formats

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countdown macro - display settings 2
New documents automatically have text in superscript 0
Indenting every other paragraph in Word at the same time? 0
Excel does not accept text format! 0
New Bug in Track Changes in Word 365 0
Paste to excel from word - auto format problem 1
Formatting question: how to format duration (time spent)? 0
How can the font and size of (all) citation numbers be altered? 1

Top