+ Reply to Thread
Results 1 to 3 of 3

Capturing Ideal system time using excel VBA

  1. #1
    Registered User
    Join Date
    12-01-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2

    Capturing Ideal system time using excel VBA

    Hi,

    I am trying to capture system ideal time on an excel. All the macro i searched does not provide this info.

    What i am trying to do is to create a time sheet, which captures any ideal time greater than 3 minute and give an overall ideal time until the activity is completed. If above 5 minutes, message box should appear altering the user.

  2. #2
    Registered User
    Join Date
    12-01-2013
    Location
    India
    MS-Off Ver
    2003 / 2007 / 2010
    Posts
    2

    Thumbs up Re: Capturing Ideal system time using excel VBA

    Idle Time.xlsm

    Hi,

    Hope the attached file should be useful to you. This captures the time if system is idle for more than 5 seconds. You could customize this for your requirement.

    Cheers

  3. #3
    Registered User
    Join Date
    12-01-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Capturing Ideal system time using excel VBA

    Thanks Nagarajan. This gives gave me the logic to proceed, however still does not meet the requirement as the sheet only looks at the active sheet (if i am in the time sheet (sheet3) the macro does not work. Sorry i was not clear earlier, this is the logic i want to use.

    1. If system is unlocked, then capture idea time if there is no mouse movement or keystrokes for more than 3 minutes
    2. if locked, capture time until user login

+ 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. Excel time slot booking system
    By genichigo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2013, 09:23 AM
  2. Capturing Date time when system is locked & unlocked
    By aravindhan_31 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-24-2012, 10:54 AM
  3. Calculating time difference between two days capturing the overnight time.
    By Monica_La in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-08-2007, 11:22 AM
  4. Capturing time from server Excel 2000
    By GP in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-20-2006, 01:45 PM
  5. [SOLVED] How to write a macro to get the system time in excel 97
    By Raj in forum Excel General
    Replies: 6
    Last Post: 04-20-2005, 03:06 PM

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