Jump to content
Macro Express Forums

Elapse Time


Recommended Posts

I've searched through the forum and didn't see anything regarding this subject but forgive me if I'm duplicating a question here.

 

I have a rather long process that runs and finishes with sending an email. I capture the time of both the start and end of the process. What I'd like to do is calculate and include in the email the elapse time of the entire process, but I can't seem to see 'the forest for the trees'.

 

Any thoughts or suggestions?

 

Thanks in advance for any help you can provide.

Link to comment
Share on other sites

I recommend that you convert your start and end measurements into seconds (for simplicity, use the beginning of the current year or month as your zero point if you don't need to handle overflows), do the subtraction and reconvert into your desired output format.

Link to comment
Share on other sites

I recommend that you convert your start and end measurements into seconds (for simplicity, use the beginning of the current year or month as your zero point if you don't need to handle overflows), do the subtraction and reconvert into your desired output format.

 

Thanks for your suggestion. That got me started in the right direction although I was hoping for built in function to speed things up. Still it's working so thanks!

Link to comment
Share on other sites

  • 2 weeks later...

I prefer to use the time variables. I save the start and complete times then subtract. Then convert to text with a format like hh:nn (hours and minutes) and use that in the email.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...