Time Tracking Sheet in Excel and VBA

Time Tracking Sheet in Excel and VBA

In this video, we will see the demo of Time Tracking Sheet in Excel and VBA. We will discuss the structure of Time Tracking Sheet and discuss the features and restrictions available in this tracker. You can use this tool to do the time and motion analysis.

Please download the Time Tracking Sheet from the below link.

If you are interested in Advanced Automated Employee Activities Tracker with Login, User Profile, Task List, Dashboard developed in Excel, VBA and MS Access the. please watch the below video.

#TimeTrackingSheet #TheDataLabs

Thanks for watching! Please like, share, comment and subscribe.

Have a great day!

[ThiagoSilva-tiop]

Thank you, sir. Amazing help, exactly what I needed.
I'd just add a Stop/Break/Resume button that would automatically stop counting and show the Actual Time once End was pressed.

[starswithbutterflies]

Thanks a lot for such an amazing sheet for work

[mjvj]

Thank you so much bro
This is really helpful in my daily routine job

[praveenj]

Thanks it's help me lot👍👍. Actually I am currently working like this file
I have question
possible to move the data to dba access?
Looking forward

[jayveecomaoay]

hi, when you click the start and end button it populated a time. i want to know how you did it. im new and im practicing excel. not sure if i just missed a part on your video but i cant find it how you did that

[Travoodvlog]

Kya aap same Google sheet ke liye bana skte ho

[avulashivaprasad]

Please provide the step by step process to create the sheet.

[abdirahmanmuhammed]

Sir, please talk about the banking system or banking database in excel and VBA.
Thanks.

[anushakm]

Hi Sir
in this video you had mentioned that you have given the link to the video on how you have created this video. I am unable to find that can you please share that video link please share that I am interested in learning how you have done this

[kailashchand]

Hello Thankyou for your quick response
could you help me with a excel query i have. I manually allocate 100, 150 cases to 5 people which is time taking process for me....Could you tell me how could i divide the 100 cases equally amount 5 user automatically in excel

[lylevincentgilay]

Greetings Sir --

Do you have time in & time out for employees in VBA in excel?

[NaveenKumar-ukxt]

Hi sir is there any macro code to create the buttons ?

[epark]

What happens if your task is not completed until the next working day which is a Monday at 8:30 am? Task was started on Thursday and workdays are Monday to Thursday? is there a way to add a column for assigned time for task vs person start time?

What if you have three tasks for that day but only have 2 end times and still have not completed the task. The next day you have a new task. This tracker the way it is does not allow for adding a new task until the all previous task has end time. How would you suggest to fix this?

Actual time will have to exclude Friday, Saturday, Sunday and if holiday falls in within those days.

[priyankanamadevan]

Can I know the video on how to create this since I’m unable to find one

[Yorumcu]

Great videos Thank you or all important VBA videos.

Master could you make a video about web scraping with Selenium sample for example geting goverment bank USD Euro and your money's paritiys last 7 day ?

[ohh_manda]

I made my first code ever today after a crash course in youtube videos. Thank you! I developed a love for coding very quickly!

For my needs, I need the start/stop times to only be entered by the code and not manually. Is that possible?

[ittips]

can we do random add project and task name?

[haditabatabaeipuor]

hello how to license an excel file with a hard drive serial number for a specific system . thanks

[jsrczzu]

Bhai ish sheet me manually time kese dale... Plz help

[fhilordona]

May I request to create also Collection Monitoring (Due Date, Account Name, Promissory Note Number, Principal, GRT, Interest Due with Total Amount Due)

Thank you, :)