Akash kothari
Member
Hi,
How can we track daily time of employee in excel. (Task1, Task2, Breaks, Meeting, Away from system - if system is idle for like 10 min.
I have attached a excel file and points which mentioned I can explain, this file I got through some website.
1) Login and Logout time - Excel should automatically start recording login and logout time as soon as employee opens this file.
2) Activity - These are the daily activity which employees normally do in office. (Can be manually done)
3) Project - Project on which employee is working.(Can be manually done)
4) Start Time / End Time - Start time and End time for the task (need to automate, as soon as employee clicks on start recording button and stop recording button)
5) Idle time - how long employee was idle on system, for each tasks (System Idle for 5 min, while working on each individual tasks). (need to automate)
6) Total activity time - is nothing but End time - Start time. (need to automate)
as soon as employee click on Stop timer that Task row details should get copied to 2nd tab with all the details 'weekly Production Log'.
Thank you
Akash
How can we track daily time of employee in excel. (Task1, Task2, Breaks, Meeting, Away from system - if system is idle for like 10 min.
I have attached a excel file and points which mentioned I can explain, this file I got through some website.
1) Login and Logout time - Excel should automatically start recording login and logout time as soon as employee opens this file.
2) Activity - These are the daily activity which employees normally do in office. (Can be manually done)
3) Project - Project on which employee is working.(Can be manually done)
4) Start Time / End Time - Start time and End time for the task (need to automate, as soon as employee clicks on start recording button and stop recording button)
5) Idle time - how long employee was idle on system, for each tasks (System Idle for 5 min, while working on each individual tasks). (need to automate)
6) Total activity time - is nothing but End time - Start time. (need to automate)
as soon as employee click on Stop timer that Task row details should get copied to 2nd tab with all the details 'weekly Production Log'.
Thank you
Akash