Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average of time spent monthly getting DIV/0 error | Excel Worksheet Functions | |||
Average time spent to # of events | Excel Worksheet Functions | |||
Running Total for Time Spent for a project in 1 month | Excel Worksheet Functions | |||
How can I show time spent? | Excel Worksheet Functions | |||
Funcation to average the Time spent | Excel Worksheet Functions |