Measure time between two points in a script

[ks100]

I'm working on speeding up a very long and complex script, and I wanted to be able to benchmark improvements I make to it, as well as how fast it runs on various machines.

What script can I use to measure two points in time?

I am assuming I would do something like

Please Login or Register  to view this content.

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

Timer function

[ks100]

It gives me readings of about 42,000 seconds for tasks that took less than a minute. are seconds the wrong unit to be measuring? What is the actual unit it's outputing in? IF I know that I Can convert it.

[AlphaFrog]

It gives me readings of about 42,000 seconds for tasks that took less than a minute. are seconds the wrong unit to be measuring? What is the actual unit it's outputing in? IF I know that I Can convert it.

The time unit is seconds. I don't now what the problem is without seeing how you implemented it.

This test should show about 5 seconds in the message box.

Please Login or Register  to view this content.

[Kenneth Hobson]

You may need to use DoEvents() in your routine.

Here is an API timer and two examples using the Timer routine in Excel similar to AlphaFrog's routine. You will need to add the class if you want to try that method.

Please Login or Register  to view this content.