Hello everyone,

Background - I am handling a big team and would like to understand how much time team members are spending on the floor most importantly what are there break timings for this I have prepared a daily activity tracker which populates time in a cell of column "C" automatically as soon as user updates anything in a cell of column "B" and have instructed all team members to update that.

Problem - I am facing problem due to few notorious guys because above mentioned arrangement works only if guys are updating there worksheet honestly but in this scenario few guys are intentionally not updating their tracker properly which is resulting improper treatment with other team members, which off course i don't want.

Solution - I am looking to develop a macro which tracks system idle time. Would like to capture time if system remains idle for 5 minutes and again would like to capture time when user starts working. I also tried goggling lot about my problem but didn't find any solution, though i found some idea that how mouse movement can be tracked to see if system is idle or not through some API. Considering i am not that conversant in VBA to be able to understand and create the code on my own.

Requesting you guys to please help me in putting together a VBA code which can do what i am expecting in "solution" section.


Thanks