Hi,
I have been working on a form to be supplied to my production floor to capture production but also wanted to have a feature where I know how much time a guy spends away from system (Non Productive).
I found a code which gets me very close to what I want but with a headache. I am unable to figure out how to get the data on a specific sheet so I can sum it up..
Need you to help me get this output on a sheet instead..
Paste the below code in a module, Open the immediate window and run printidletime1. Every 5 seconds you would see immediate window popping up the idle time.
Bookmarks