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...🎉🎉👍👍👍
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
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....
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.
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
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?
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
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
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
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!
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
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
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.
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 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
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!
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
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
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
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?
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!
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
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.
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
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
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.
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.
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!
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.
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?
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!
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 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"
1st tyvm for this but I can't complete this...I did everything exactly like you did but I get Run-Time error '9": Subscript out of range....what should I do
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
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.
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...🎉🎉👍👍👍
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
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....
Thanks for your appreciation!
The data lab learning process is very useful and intresting to learn vba program.sir jee
This tutorial is so easy to follow and fun! Thank you!
Glad it was helpful!
Excellent. Explained well in a simple way.Thanks
Thank you sir it's really helpful for the working people😊
Thank you kind sir! This is very helpful since management has tasked me to do a TMS for my team.
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..
Thanks a lot for the great tutorial and sample file.
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
Hey man Thanks so much for this! more power to you!
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?
Thanks for the tutorial! Extremely helpful
This was very helpful. Thanks!
I love the step by step more videos on this please? thanks
Great tutorial. Thank you!
Hi Dilip, this is a wonderful tutorial..I tired to my need and it woks perfectly.. Thank You !
I tried the same code I am getting bugs
Wow Amazing Tutorial
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! I'm learning 😊😊
can we add hold and resume buttons as well please
thank you so much!!
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
Thanks for the content. Very helpful
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
Youre a damn Genuis!!! Thank you!!!!
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
Great video thank you
Thanks for your feedback!
Nice....one
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!
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
Thank you so much
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
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.
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?
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 🙏
Thanks for your feedback! You can find the download link in the description box.
Ithanks
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
Thanks for your appreciation! You can find the below mentioned video useful.
ruclips.net/video/vGXkY6ppEFk/видео.html
@@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
Sure, you can watch the version 2.0 of this tool. Hopefully that will be useful in your scenario. Thanks!
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!
Awesome
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
Great! btw how do I change the employee name?
Hi @TheDatalabs, is it possible to have time trackers in multiple sheets?
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
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
I want to change end time manually so that i can calculate when i forgot to end my task.
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?
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!
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
Sheet1 should be "sheet1" in third line. Thanks!
This is great. Question, How can I insert a visible timer in H5 to view the count when start is selected.
Can you make the start and end time lockable so that they can't manipulate the data?
Can I do the tacker in excel in 2 sheets within same excel?
Hi sir, once start time & end time captured, how to lock both the columns not to edit ?
Many time requested to make school management sir merzi h apki
How can you protect the sheet so the macro input data will not be edited? Help on here please. Thanks in advance.
Very use fuil sir one doubt how to enter before taking list
Can someone give me the code to protect the start date ,end date and total time columns being edited by others
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.
thanks for great code. how can we protect time captured on make it un editable
I want to add day 2 activity as well ...and combine both day 1 and day 2 time...is it possible ?? Its urgent
Please watch our Fully Automated Employee Activities Tracker video. You can also download the tool from our website. Thanks!
Sir please share video how to record data certain time interval from automated Excel
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.
are you able to create pause and resume?
Hi Sir, Can it share or use with multiple computers? Thanks
What if I need to update the end time ? Will it auto update the total time if I update the end time manually?
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
Can I do the tacker in excel in 2 tabs?
I tried preparing it and it worked. Just one query here we can edit the updated time. How to stop this editing?
You can apply protection on these columns. You can download the new time sheet tracker from our website. Thanks!
Hi 😊 its possible have a pause botton too?
Yes, it's possible.
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
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
Can we do different task on one sheet
if i want to create the start and end button on each line..does it use the same coding?
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
So employees details are system updated. System is taking user id. You can create the employee list and use as a drop-down.
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.
Please check the below tutorial. Hop you will find it useful. Let me know if you different question. Thanks!
ruclips.net/video/vGXkY6ppEFk/видео.html
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.
Hi, You want to close what?
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.
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!
Thanks for your feedback! Please make changes in date time entry. Thanks!
@@thedatalabs thank you!! 🎉
Most welcome!
Can you help to create one productivity sheet
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.
Can we add pause button to this
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?
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?
Can someone explain the iRow variable in the initialized function and what it does?
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!
What if I wanted two tabs running with the same code?
How can I protect the start, end time to avoid any manipulation
how to lock cell F and G so no one can manipulate tim as I am getting dbug error
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"
Thank you very much. i mistook in spelling and have corrected it,
Thank you so much brother. you have made my job easy!!!!!!
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?
Also please advise how can i protect cells or columns when time is captured with password?
@@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"
How should I add pause button also in this sheet ?
Please watch this tutorial. Hope, you find it useful.
ruclips.net/video/Hgk5IBNA5Wo/видео.html
Can we run this code in Google sheet script ?
1st tyvm for this but I can't complete this...I did everything exactly like you did but I get Run-Time error '9": Subscript out of range....what should I do
Please share the line of code where error is showing. Thanks!
@@thedatalabs I get the same for iRow = Sheets("T&M").Range("h" & Application.Rows.Count).End(x1up).Row + 1
@@mariadevlin7885 same error here
Sir userform command button ko short cut key assign kar saktay ha ya Ni please help me
Yes, we can do. Please click on Option Button and then assign shortcut key in Macro window.
Hi Sir... I am getting error " can not merge changes made by another user".. When multiple user work at same time. kindly suggest
This has been designed for single user only. It will not run in shared mode. Thanks!
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.
Shall i know what is irowsheets?
Please share the complete line of code where this variable is used. Thanks!
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
i am having same issue.
I want another date to be capture in next row how I can do that?
Did not work need help on task, since I don't need them to select the task anymore then can just put any value
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
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