+ Reply to Thread
Results 1 to 5 of 5

Time between file opened and file closed?

  1. #1
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,007

    Time between file opened and file closed?

    Greetings,
    1- Open enclosed file.
    2- Close enclosed file
    3- See that MsgBox shows;
    Opening Time:16:17:21
    Closing Time :16:17:41


    The question is how to show difference time between Opening Time and Closing Time...

    So the MsgBox must shows;
    Opening Time:16:17:21
    Closing Time :16:17:41

    Difference Time: 00:00:20

    So, this question is kind of formatting issue...(I think...)


    Regards...
    Last edited by HerryMarkowitz; 04-24-2015 at 09:26 AM.
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,841

    Re: Time between file opened and file closed?

    Show the code that displays the open and closed times and I can show you the code to display the difference. You can do arithmetic on dates.

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,007

    Re: Time between file opened and file closed?

    Thanks a lot...Solved...

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,841

    Re: Time between file opened and file closed?

    I congratulate you on solving it with an error in my code. The "-" key is right next to the "=" key....

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,007

    Re: Time between file opened and file closed?

    Quote Originally Posted by 6StringJazzer View Post
    I congratulate you on solving it with an error in my code. The "-" key is right next to the "=" key....
    Thank you... But where is my reputation point ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 04-19-2021, 06:44 AM
  2. [SOLVED] How to see time between file opened and file closed?
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-24-2015, 08:06 AM
  3. Excel 2010 crashes after 2nd file is opened as read only and then closed
    By tv69 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-22-2014, 03:53 PM
  4. Replies: 3
    Last Post: 02-25-2013, 03:18 PM
  5. Macro to open/close a file only if it isn't already opened/closed
    By catccc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2010, 10:27 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1