I need a macro to count times I type in a word file.
but if i have less than 5 minutes break between typing, it should just continue counting.
but if I stop typing more than 5 minutes, it should stop the time.
it should save the times and names of the word files in a google excel sheet.
if user spend 30 minutes writing in microsoftword.docx, it adds
12:23/2018 9:25am to 9:55am microsoftword.docx
It can have a timer that when user opened a word file but don't type anything for 5 minutes, it should stop the timer. and when user resume typing again, it should start the time again.
the app should detect if the user is active on a open process. like if the 123.docx is open but user hasn't typed anything for 5 minutes, it should stop the time for that file. like when the user is going away from his desk, but didn't close the 123.docx file. for when the user stops working on 123.docx for 5 minutes, it can record it as inactive time. I think that makes it easier.