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



"Richard" wrote:

If you can't help please don't respond

"pinmaster" wrote:

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

"Richard" wrote:

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.

If you can't help please don't respond

"pinmaster" wrote:

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

"Richard" wrote:

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.

=now() is not automatic now is it

"Nikki" wrote:

=now()

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

=now()

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

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

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

"Richard" wrote:

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.

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.