Evaluate time spent on macro running
 

I was thinking of retrieving the time at the beginning of the macro, eg
in 10:31:02 converted to seconds (=37802 or sth) and then the time of
"seconds" at the end. Then subtract it and voila - convert it to
minutes and seconds (the macro runs for about 2-5 mins.

Is there any quick way to do that? Or is there a smarter way?

Cheers

Evaluate time spent on macro running
 

Sub RunTimer()
Dim nTime As Double
Dim i As Long, j As Long

nTime = Timer
For i = 1 To 1000000
For j = 1 To 100
Next j
Next i

MsgBox Format((Timer - nTime), "0.0 ""seconds""")
End Sub

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Morris" wrote in message
ups.com...
I was thinking of retrieving the time at the beginning of the macro, eg
in 10:31:02 converted to seconds (=37802 or sth) and then the time of
"seconds" at the end. Then subtract it and voila - convert it to
minutes and seconds (the macro runs for about 2-5 mins.

Is there any quick way to do that? Or is there a smarter way?

Cheers