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

"Kevin B" wrote:

=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.


--
Kevin Backmann


"Richard" wrote:

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.