Time & Motion Tracker in Excel - Step by Step Tutorial
How to develop Time and Motion Tracker in Excel
In this tutorial, we will learn how to create Time & Motion Tracker in Excel and VBA. We will write Sub Procedure for Start Time, End Time and Initialize date and employee name.
This is step by step tutorial and after watching this video, you will be able to create Time and Motion template in Excel. Please post your questions and feedback in comment section.
#TimeAndMotion #TheDataLabs
Please follow the below link to download the Excel files (Time & Motion) used in this video.
thedatalabs.org/time-and-moti...
Please visit our website www.thedatalabs.org
Please contact us on thedatalabs@gmail.com
Thanks for watching!
Please like, share, comment and subscribe.
Have a great day!
Пікірлер: 159
i am sooo glad i came across your video!! i am a quality control specialist and i need to do time in motion for our staff!! this saved my time.... thanks for this helpful vid.... its pretty good!! i love how effective this is
I can't thank you enough on your tutorials...they are so easy to understand and follow..you are my excel life saver!!! 😂😂😂..I'm so glad that there are people like you who never hesitate to share their knowledge...I struggle so much w/ excel but so much instrested on learning them...Please keep making these videos, you are making a big impact on people like me..More power and more subscribers to come...🎉🎉👍👍👍
Thanks for the tutorial! Extremely helpful
Hey man Thanks so much for this! more power to you!
This is really an amazing tool.....this does track all our tasks that this being done every day....Thank you so much for such a good tool....greatly appreciated....
@thedatalabs
4 жыл бұрын
Thanks for your appreciation!
Excellent. Explained well in a simple way.Thanks
Thank you so much! I'm learning 😊😊
Great tutorial. Thank you!
Thank you kind sir! This is very helpful since management has tasked me to do a TMS for my team.
The data lab learning process is very useful and intresting to learn vba program.sir jee
Thanks for the content. Very helpful
Thanks a lot for the great tutorial and sample file.
This was very helpful. Thanks!
Hi Dilip, this is a wonderful tutorial..I tired to my need and it woks perfectly.. Thank You !
@dineshkandanuru
3 ай бұрын
I tried the same code I am getting bugs
thank you so much, this is very helpful, would just like to know if we could also lock the cells F,G & H please, to prevent data manipulation on the employees end.
Sir, it is very helpful and would recommend you to include break time as well..appreciate your effort sir..
I love the step by step more videos on this please? thanks
This video answers part of what I’m working on. For instance if employee start time is 7:00 am and employee doesn’t start working on the task until 7:30 am what method of tracking would you recommend to track that plus deduct three break schedules: 1 hr lunch and two 15 min breaks if time on task is not completed between those three breaks. Thank you for your assistance
thank you so much!!
Thank you sir it's really helpful for the working people😊
Wow Amazing Tutorial
This tutorial is so easy to follow and fun! Thank you!
@thedatalabs
8 күн бұрын
Glad it was helpful!
Youre a damn Genuis!!! Thank you!!!!
This is helpful! Thanks. What if you want the end time value to be automatically copied to the next row under start time when you press the end time button? Thank you so much
I am a new learner and I am enjoying your videos, this is a great example I can use for exam testing. The question is what if I have multiple employees and I want to test at different times? May select employee name? how?
Hi. thanks for a great video. if you wanted to insert a pause button where would you put the code and what would it look like?
This is great. Question, How can I insert a visible timer in H5 to view the count when start is selected.
Great tutorial, thanks a lot! A question as I have already created the time and motion tracker but I wish more than one users to click on the start end end button at the same time. So I wish to have more than one users working on an online shared version of it
Great video thank you
@thedatalabs
7 ай бұрын
Thanks for your feedback!
Hi Thanks for this time and motion tracker. I am learner I want to ask you where I should edit in module that instant of employ name can be change in every time like I have 30 employ there should can add another dropdown list?
This is very cool, I'm trying to figure out how to get the date to populate on the current row rather than the next row, is there an easy answer? I didn't add the employee command and don't need the next row to start with a date, I'm using this to track trucks in and out with load times. Thank you!
Hi This is a very helpfull. Request you to show how and which code need to Clear/Reset Data in the same sheet.
Thank you so much
Thank you for this tutorial. Everything work as expected except for “This Workbook”. I encountered Compile error Sub or Function not defined. I hope you could help on this. Thank u in advance. Keep safe!
Nice....one
Awesome
Ithanks
Hi Sir, it's very useful tool to my team. I would like to add pause and resume to the sheet. Kindly provide me the code for that As people might need to take a break so the need to pause but have not completed the task and then would need to resume and would not want the down time to be captured in the elapsed time, maybe a different tracker would be need, more like a stop watch with a timer instead that has start,pause,resume,stop and then total time
Very useful Also, please help in the below I have added two more columns after total time. 1st column is for number of transactions and other one is for average time taken per transaction how to write the code for this so that if i click average button without total count it shows pop up of please enter the value then once i enter the value and click the button it shows me time taken per transaction and at the same time enter the name and time in next line. Please help. Its urgent
Thank you so much for this tutorial….i have one question About the date what if i need next date insted of same date when i click on end time…Thanks Weating for your riply
thanks for great code. how can we protect time captured on make it un editable
if i want to create the start and end button on each line..does it use the same coding?
Can someone give me the code to protect the start date ,end date and total time columns being edited by others
I appreciate your efforts and hard work - your just Amazing, Is there a way to create the same time tracking sheet for multiple activities - Can you please make a video on it
@thedatalabs
3 жыл бұрын
Thanks for your appreciation! You can find the below mentioned video useful. kzread.info/dash/bejne/qHuMzbtvoNOrds4.html
@harshavardhana5907
3 жыл бұрын
@@thedatalabs Yes I have seen the video but this is for single activity and i need a video tutorial on Multiple activities - please help - Thanks in Advance
@thedatalabs
3 жыл бұрын
Sure, you can watch the version 2.0 of this tool. Hopefully that will be useful in your scenario. Thanks!
Hi Sir, Can it share or use with multiple computers? Thanks
How can you protect the sheet so the macro input data will not be edited? Help on here please. Thanks in advance.
Sir please share video how to record data certain time interval from automated Excel
can we add hold and resume buttons as well please
Hi Sir, it's very useful tool to my team. I would like to add pause and resume to the sheet. Kindly provide me the code for that.
@kizzethkizz1275
Жыл бұрын
are you able to create pause and resume?
Hello sir its a wonderful and informative video and its a realy help full but I'm facing one error in this tool its not automatic show me the date and employee name i need to click on play button from visual basic code window every time can you help me with this scenario
The title Time and Motion... had me looking at this video to see if your spreadsheet received GPS data to be able to record motion (like a vehicle moving along a path). That is not the case. It appears your title may not be aptly named. Do you mean to say, "Time IN Motion Tracker"? Or maybe you mean to say, "Time and ACTIVTY Tracker"? Thank you for this useful tool!
I want to change end time manually so that i can calculate when i forgot to end my task.
Good info.. But I have query... You have not defined codes for deleting date & employee name from last row for which task is not started. So when user opens the workbook next time date shown in the sheet will be of when it was opened last time may be same day or any other previous days,... Either we can make entire worksheet blank for fresh use next time it's opened
@thedatalabs
4 жыл бұрын
Thanks for your feedback! If task is not started and Date and Username is filled then that will be automatically updated with latest Date and Employee name if user will open next time.
Great! btw how do I change the employee name?
Hi @TheDatalabs, is it possible to have time trackers in multiple sheets?
@raymondindico7108
3 жыл бұрын
Tried to make a duplicate of the sheet and change some sheet names in the code, and it brought me this: Private Sub Workbook_Open() Call Initialize End Sub
What will happen, say the operations close at 6pm, and a task is not yest completed? Is it possible to autopark a task till tomorrow at 6am?
Very use fuil sir one doubt how to enter before taking list
Very useful video, I have a doubt . In this video if we end date and username will automatically entered I need that in start time . How can I do that Can you please help me in this
Can I do the tacker in excel in 2 sheets within same excel?
What if I need to update the end time ? Will it auto update the total time if I update the end time manually?
Hello, Question for you. This is great! However, i want to close it so that if the start time or end time is edited manually it will recalculate the total time. Can someone explain how this can be done? Any help is much appreciated.
@okayox7819
3 жыл бұрын
Hi, You want to close what?
Hi Dilip, is there anyway I can connect with you? I need to know few things and would not be able to type the whole thing over here... I shall be grateful to you if we can connect either on phone or through any application. Pls do reply.
Having Issue with initialize. I get a run-time error '1004': Method 'Rows' of object '_Application' failed when I hit the enable button after opening the spreadsheet. This is the row that is highlighted when I hit debug iRow = Sheets("Crew1").Range("F" & Application.Rows.Count).End(xlUp).Row + 1 (note I only have columns going to F, I didn't use as many columns.
Can you make the start and end time lockable so that they can't manipulate the data?
Can you help to create one productivity sheet
Can I do the tacker in excel in 2 tabs?
Hi data labs iam getting error on workbook call initialize sheet when ever I open the workbook i had to manually run the macro can u help me please
I want to add day 2 activity as well ...and combine both day 1 and day 2 time...is it possible ?? Its urgent
@thedatalabs
4 жыл бұрын
Please watch our Fully Automated Employee Activities Tracker video. You can also download the tool from our website. Thanks!
Can someone explain the iRow variable in the initialized function and what it does?
@thedatalabs
3 жыл бұрын
iRow variable has been used to identify and store the current blank row in Database sheet so that data can be transferred to that particular row only. Thanks!
Can we run this code in Google sheet script ?
Many time requested to make school management sir merzi h apki
Hello Team, while clicking 'End time' I receive an error = Run-time error '9'. when debugged, the session takes me to this line -> Sheets("Timesheet").Range("H" & iRow).Value = Sheets("Timesheet").Range("G" & iRow).Value - Sheets("Timesheet").Range("F" & iRow).Value Any suggestions on fix please?
Can we do different task on one sheet
Hello sir first of all i would like thank you for all of your videos. Request you to please can you share file download link if possible. Thanks 🙏
@thedatalabs
Жыл бұрын
Thanks for your feedback! You can find the download link in the description box.
Hello sir i'm facing this error iRow = Sheets("T&M").Range("H" & Application.Rows.Count).End(xlUp).Row + 1 when i compile second workbook can you please give a solution for it, thanks
How to lock cells automatically post entry. I tried different code available on youtube but code doesn't work with the existing coding. Please help.
Hye Sir, I have a question for you. How to give multiple user start their time as well like first user. It like the attendance for employee to clock in and clock out after finish their working hour.
@thedatalabs
3 жыл бұрын
Please check the below tutorial. Hop you will find it useful. Let me know if you different question. Thanks! kzread.info/dash/bejne/qHuMzbtvoNOrds4.html
Question...where does it pull the employee details from? Can you leave this blank or can the user populate this using a drop down box? Thanks
@thedatalabs
3 жыл бұрын
So employees details are system updated. System is taking user id. You can create the employee list and use as a drop-down.
Hi there, it is showing error in 3rd line. plz assist me. thank you. Sub start_time() Dim iRow As Long iRow = Sheets(Sheet1).Range("H" & Application.Rows.Count).End(xlUp).Row + 1 If Sheets("sheet1").Range("D" & iRow).Value = "" Then MsgBox "Please select an Activity.", vbOKOnly + vbInformation, "Activity Name" Sheets("sheet1").Range("D" & iRow).Select Exit Sub
@thedatalabs
Жыл бұрын
Sheet1 should be "sheet1" in third line. Thanks!
Hi, That's a great effort! However whenever we start a second task or the second line item the start time must be same as previous end time. An employee works 9 hrs a day and from start time till end time the total time taken should be equal to 9 hrs. But in this method if a employee logs in by 9 am and works till 10 am and clicks end. But he goes for break by 10.5 am and clicks start time. Now the last end time will be 10. Am and next line items start time would be 10.5 Am which is not logic. Please suggest if we could arrest this issue. Thank you!
@thedatalabs
3 жыл бұрын
Thanks for your feedback! Please make changes in date time entry. Thanks!
@subbukasi9480
3 жыл бұрын
@@thedatalabs thank you!! 🎉
@thedatalabs
3 жыл бұрын
Most welcome!
I want another date to be capture in next row how I can do that?
how to lock cell F and G so no one can manipulate tim as I am getting dbug error
I tried preparing it and it worked. Just one query here we can edit the updated time. How to stop this editing?
@thedatalabs
3 жыл бұрын
You can apply protection on these columns. You can download the new time sheet tracker from our website. Thanks!
How to use conditional command in vba .sir jee
What if I wanted two tabs running with the same code?
Can we add pause button to this
How can I protect the start, end time to avoid any manipulation
Sir userform command button ko short cut key assign kar saktay ha ya Ni please help me
@thedatalabs
4 жыл бұрын
Yes, we can do. Please click on Option Button and then assign shortcut key in Macro window.
How can I put control to unchange time. Now anyone can change time manual
How do I duplicate this worksheet? I make a copy but I get the error 1004.
Hi 😊 its possible have a pause botton too?
@thedatalabs
5 күн бұрын
Yes, it's possible.
Does anyone know how to fix this error? Run-time error '9': Subscript out of range - iRow = Sheets("T&M").Range("H" & Application.Rows.Count).End(xlUp).Row + 1
@blueheart2543
2 жыл бұрын
i am having same issue.
Hi Sir... I am getting error " can not merge changes made by another user".. When multiple user work at same time. kindly suggest
@thedatalabs
3 жыл бұрын
This has been designed for single user only. It will not run in shared mode. Thanks!
How should I add pause button also in this sheet ?
@thedatalabs
Жыл бұрын
Please watch this tutorial. Hope, you find it useful. kzread.info/dash/bejne/epufl6t7fqSbh9I.html
I am unable to get total time and unable to automatically go to nextvtab
Hi,, thanks for this but i got an error on this line Sheets("T&M").Range("H" & iRow).Value = Sheets("T&M").Range("G" & iRow).Value - Sheets("T&M").Range("F" & iRow).Value :( can you please help
@billiemartin8284
3 жыл бұрын
Same here. However I noticed what I had wrong was the sheet name. On the sheet tab I had spaces while in the code I didn't. Once I corrected the spaces it worked. I hope this helps.
Coditional command like if one hour pay 100 then for two hour 200 so on
Shall i know what is irowsheets?
@thedatalabs
Жыл бұрын
Please share the complete line of code where this variable is used. Thanks!
Did not work need help on task, since I don't need them to select the task anymore then can just put any value
Followed your instructions thoroughly, but still below is the error showing when clicking on 'Start button'. Please advise. Sheets("T&M").Range("G" & iRow).NumberFormat = "hh:mm:ss AM/PM"
@travelmood4543
4 жыл бұрын
Thank you very much. i mistook in spelling and have corrected it, Thank you so much brother. you have made my job easy!!!!!!
@travelmood4543
4 жыл бұрын
Could you please advise if i want to add columns next to task then will it cause any problem to the sheet? Will 'start' and 'end' work after changes?
@travelmood4543
4 жыл бұрын
Also please advise how can i protect cells or columns when time is captured with password?
@okayox7819
3 жыл бұрын
@@travelmood4543 add this at the top of the code after the sub() ActiveSheet.Unprotect Password:="yourpassword" . then add this before the end sub. ActiveSheet.Protect Password:="yourpassword"