software

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
quot;Richardquot; wrote:

gt; If you can't help please don't respond
gt;
gt; quot;pinmasterquot; wrote:
gt;
gt; gt; I can't help you with your problem but I do have a suggestion.......lose the
gt; gt; attitude if you want people to help you.
gt; gt;
gt; gt; Regards
gt; gt; JG
gt; gt;
gt; gt; quot;Richardquot; wrote:
gt; gt;
gt; gt; gt; I realize =now() is the systems time but it's not automatic now is it. And
gt; gt; gt; thats what i am looking for
gt; gt; gt;
gt; gt; gt; quot;Kevin Bquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; =now() will do the trick, but it doesn't tick lick a watch. It only updates
gt; gt; gt; gt; upon recalc, which is when a change is made to the worksheet, you press F9 or
gt; gt; gt; gt; the file is retrieved.
gt; gt; gt; gt;
gt; gt; gt; gt; You could write some VBA code and set the recalc to a timer, but that could
gt; gt; gt; gt; pose problems in a large workbook containing many formulas.
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Kevin Backmann
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Richardquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Is there a way to have the date and time in cell g2 to constantly show the
gt; gt; gt; gt; gt; currect time and date every second. Like a watch with a second hand.

If you can't help please don't respond

quot;pinmasterquot; wrote:

gt; I can't help you with your problem but I do have a suggestion.......lose the
gt; attitude if you want people to help you.
gt;
gt; Regards
gt; JG
gt;
gt; quot;Richardquot; wrote:
gt;
gt; gt; I realize =now() is the systems time but it's not automatic now is it. And
gt; gt; thats what i am looking for
gt; gt;
gt; gt; quot;Kevin Bquot; wrote:
gt; gt;
gt; gt; gt; =now() will do the trick, but it doesn't tick lick a watch. It only updates
gt; gt; gt; upon recalc, which is when a change is made to the worksheet, you press F9 or
gt; gt; gt; the file is retrieved.
gt; gt; gt;
gt; gt; gt; You could write some VBA code and set the recalc to a timer, but that could
gt; gt; gt; pose problems in a large workbook containing many formulas.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Kevin Backmann
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Richardquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Is there a way to have the date and time in cell g2 to constantly show the
gt; gt; gt; gt; currect time and date every second. Like a watch with a second hand.

=now() is not automatic now is it

quot;Nikkiquot; wrote:

gt; =now()
gt;
gt; quot;Richardquot; wrote:
gt;
gt; gt; Is there a way to have the date and time in cell g2 to constantly show the
gt; gt; currect time and date every second. Like a watch with a second hand.

=now()

quot;Richardquot; wrote:

gt; Is there a way to have the date and time in cell g2 to constantly show the
gt; 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 Backmannquot;Richardquot; wrote:

gt; Is there a way to have the date and time in cell g2 to constantly show the
gt; 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

quot;Richardquot; wrote:

gt; I realize =now() is the systems time but it's not automatic now is it. And
gt; thats what i am looking for
gt;
gt; quot;Kevin Bquot; wrote:
gt;
gt; gt; =now() will do the trick, but it doesn't tick lick a watch. It only updates
gt; gt; upon recalc, which is when a change is made to the worksheet, you press F9 or
gt; gt; the file is retrieved.
gt; gt;
gt; gt; You could write some VBA code and set the recalc to a timer, but that could
gt; gt; pose problems in a large workbook containing many formulas.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Kevin Backmann
gt; gt;
gt; gt;
gt; gt; quot;Richardquot; wrote:
gt; gt;
gt; gt; gt; Is there a way to have the date and time in cell g2 to constantly show the
gt; gt; gt; 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

quot;Kevin Bquot; wrote:

gt; =now() will do the trick, but it doesn't tick lick a watch. It only updates
gt; upon recalc, which is when a change is made to the worksheet, you press F9 or
gt; the file is retrieved.
gt;
gt; You could write some VBA code and set the recalc to a timer, but that could
gt; pose problems in a large workbook containing many formulas.
gt;
gt;
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;Richardquot; wrote:
gt;
gt; gt; Is there a way to have the date and time in cell g2 to constantly show the
gt; gt; currect time and date every second. Like a watch with a second hand.