Results 1 to 7 of 7

Thread: Calculating elapsed time between starting and closing excel

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    VBAX Regular
    Joined
    Mar 2015
    Posts
    31
    Location
    This works perfectly
    Thanks a lot Mr. Paul_hoosler for this great code and your explanation

    is there a way to do that :

    if Elapsed time < 60 seconds msgBox become to "This worbook open for hh:mm:ss seconds"

    if Elapsed time > 60 seconds msgBox become to "This worbook open for hh:mm:ss minutes"
    Thanks again !!
    Last edited by mokhtar; 04-22-2015 at 03:31 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •