Current date and time updated automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to have the date and time in cell g2 to constantly show the
currect time and date every second. Like a watch with a second hand.
 
ppl are trying to help you,,, but the sarcastic answers your giving are not
helping your cause,,, especailly since ppl are not answering a question you
yourself can not answer

both the answers you are given are correct in their suggestions
but excell is not a watch,, set the autosave to save your workbook once a
min and you will have a clock of sorts,, but if you want seconds ect then
either buy a watch or look for another program
 
If you can't help please don't respond

pinmaster said:
I can't help you with your problem but I do have a suggestion.......lose the
attitude if you want people to help you.

Regards
JG
Click to expand...
 
=now() will do the trick, but it doesn't tick lick a watch. It only updates
upon recalc, which is when a change is made to the worksheet, you press F9 or
the file is retrieved.

You could write some VBA code and set the recalc to a timer, but that could
pose problems in a large workbook containing many formulas.
 
I can't help you with your problem but I do have a suggestion.......lose the
attitude if you want people to help you.

Regards
JG
 
I realize =now() is the systems time but it's not automatic now is it. And
thats what i am looking for
 
Back
Top