Time please

[Stig - tame racing driver]

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

E.g. =now()

Regards
Derek

 

[John Bundy]

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

 

[Harald Staff]

Hi Derek

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

HTH. Best wishes Harald

 

[Stig - tame racing driver]

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

Cheers for that

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

 

[Stig - tame racing driver]

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

Hi Derek

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

HTH. Best wishes Harald