Can you add the current time to a cell which auto updates by the second ??

E.g. =now()

Regards
Derek

i'm not sure i would ever do it, with the system timer in the bottom right
corner of most screens and the time only changing every minute, but here you
go. Put in a module and don't plan on running other code.

Sub MyTimer()
Do
Application.Wait Now + TimeValue("00:00:01")
sheet1.cells(1,1)="=now()"
Loop
End Sub

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Stig - tame racing driver" wrote:

Can you add the current time to a cell which auto updates by the second ??

E.g. =now()

Regards
Derek

Hi Derek

http://www.mvps.org/dmcritchie/excel/datetime.htm#clock

HTH. Best wishes Harald

"Stig - tame racing driver" wrote in
message ...
Can you add the current time to a cell which auto updates by the second ??

E.g. =now()

Regards
Derek

Nice one..........

Cheers for that


"John Bundy" (remove) wrote in message
...
i'm not sure i would ever do it, with the system timer in the bottom right
corner of most screens and the time only changing every minute, but here
you
go. Put in a module and don't plan on running other code.

Sub MyTimer()
Do
Application.Wait Now + TimeValue("00:00:01")
sheet1.cells(1,1)="=now()"
Loop
End Sub

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Stig - tame racing driver" wrote:

Can you add the current time to a cell which auto updates by the second
??

E.g. =now()

Regards
Derek

Cheers...........

"Harald Staff" wrote in message
...
Hi Derek

http://www.mvps.org/dmcritchie/excel/datetime.htm#clock

HTH. Best wishes Harald

"Stig - tame racing driver" wrote in
message ...
Can you add the current time to a cell which auto updates by the second
??

E.g. =now()

Regards
Derek