second(now())

R

R. Langdon

Hey,

I need a realtime time (seconds ) function in a cell.
second(now()) is not a realtime function. I need to push F9 to have the real
time calculated.

Do I need vba for this and how?


Greets,

R. Langdon
 
G

Gary''s Student

Try:

Sub time_it()

For i = 1 To 10

Application.Wait Now + TimeValue("00:00:01")
Cells(2, 2) = Format(Time, "hh:mm:ss")
Next i
End Sub



for a 10 second example
 
R

R. Langdon

This will work but it slowsdown the sheet. I see a 10 seconds hourglass.
Thanks, I can start with this.

R. Langdon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top