Is there a way to see how long a macro took to complete
Use the SECONDS() function:
SECONDS()
For more information, see the wiki Searching the Forum for Answers section.
