I wrote a fairly detailed time tracker that lets you run a bunch of sub-times during the macro run, so you can see how long each section takes:
-rob.
For more information, see the wiki Searching the Forum for Answers section.