Time Tracker

I have team of 35 people. I want to track their time on task basis I mean they should enter start time and end time of a task and it should not be editable. Also, i want total time spend should be calculated automatically. Can we add one more thing like if a person is in middle of one task and he went for break then break time should start and then after ending break time he should be able to enter end time for that incomplete task.

I am very much new to excel but i want it to be done so that i can calculate productivity and efficiency for a particular team member.

Thanks in advance.

Please clarify the below mentioned.

Will they be entering the values when they go for break or should it be auto captured from the System.

And how will they be using the excel assuming it would be on a shared platform.

Hi Kiran,

I have prepared one with start and end button now i just wanted to know how can i protect it with password as when i'm doing it it is asking for password in start and end buttons as well... I will share the file it will give you clear idea.

Thanks for the help

And yes i will be using this file on shared platform or i can do one thing this file will be kept in personal folder of each user on a shared drive...

If you dont want the sheet to be protected all you have to do is amend the script as mentioned in below.

ActiveSheet.Unprotect


Assuming this answered your query.

i want my user should have access to only 2 columns i.e. task and number of orders and also they should be able to click on those start and end buttons other fields should be password protected.

can we do that??