When you insert "=now()" into a cell which is set to a time mode (14:05:07), how can I see the seconds counting?

print out 60 copies and make a flick book?

Press F2 and enter once a second

Is ST Failing me???????

you need a VBA loop.

Dont think you can do it without a custom function though Stoner will be along in a minute to prove me wrong 🙁

print out 60 copies and make a flick book?

Nice.

why not get a watch?

I spend too much on bikes! 😉

Sub count_time()
Range("A1").value = now()

While 1 = 1
Range("A1").Calculate
Wend

End Sub

Will have to use Ctl+C to kill it though 🙂

STW has its limits (though I haven't reached them yet) so you might want to try here.

Mr Excel

SR – Whats that formula in thicko terms?

the first google search of excel clock reveals the vba you need to do this.

ok 😥

Whos_Daddy

Its VBA you have to go hit alt+F11 to go to the VBA editor.
Paste in the code.
go back to your worksheet.
add the forms toolbar.
draw a button on the sheet.
assign your macro to the button

click button and it will refresh the cell in a never ending loop.
Not pretty but thats what he asked for 😉

Ctl+C to kill the loop.

🙂

You could easily put a time constraint in :
Sub count_time()
Dim bob as date
bob = now()+ 0.001
Range("A1").value = now()

While now() <> bob
Range("A1").Calculate
Wend

End Sub