Time Tracking Sheet in Excel and VBA
ฝัง
- เผยแพร่เมื่อ 25 ม.ค. 2021
- 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.
thedatalabs.org/time-tracking...
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.
• Fully Automated Employ...
website - www.thedatalabs.org
email - info@thedatalabs.org
#TimeTrackingSheet #TheDataLabs
Thanks for watching! Please like, share, comment and subscribe.
Have a great day!
![หมานแต่ผัวเขา - แสตมป์ โตเกียวมิวสิค [ OFFICIAL MUSIC VIDEO ]](http://i.ytimg.com/vi/m0g1TSBJPgo/mqdefault.jpg)
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.
Thank you so much bro
This is really helpful in my daily routine job
Yeah.. tq
Sir, please talk about the banking system or banking database in excel and VBA.
Thanks.
Thanks a lot for such an amazing sheet for work
Thanks for your feedback!
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
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 ?
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.
Please provide the step by step process to create the sheet.
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
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
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, :)
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
hello how to license an excel file with a hard drive serial number for a specific system . thanks
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?
how about pause one activity and start another task and once you end the task it will calculate the actual time spent
are you talking about tracking multiple activities?
Kya aap same Google sheet ke liye bana skte ho
I am new to VBA and know this is not exactly related to this video but am wanting to do a project and create a userform/database that, in part takes, ANY date ENTERED by the user + an ANY amount of days ENTERED by the user, say 4/3/2021 + 5 days = 9/3/2021 and then add that 5 days repetitively to each consecutive date i.e. 4/3/2021, 9/3/2021, 14/3/2021, 19/3/2021 all within a set time frame say between March and August. I am following DataLabs but unable so far to find anything that may help or anything on the internet. Everything seems to be about calculating between given dates which is not what I want to do. Can anyone help me with this. Thankyou.
How to prepare employee name and client wise time monitoring.
Hi sir is there any macro code to create the buttons ?
Hello sir, The excel sheet which Fetches option chain data from NSE website is currently giving runtime error problem, please check. Thanks in advance 👍
I will try to update this tracker and link with new website. Thanks!
@@thedatalabs Thanks a lot👍
Bhai ish sheet me manually time kese dale... Plz help
Greetings Sir --
Do you have time in & time out for employees in VBA in excel?
Hello, please check this video.
th-cam.com/video/vGXkY6ppEFk/w-d-xo.html
can we do random add project and task name?
How to edit time?
can i get this for google sheets
Can I know the video on how to create this since I’m unable to find one
Please download the file. Link is provided in the description box.
How to bild this sheet
Password to unprotect sheet?
I want to skip in saturday ur sunday what is solution?
How to make this sheet is what I came here for but found nothing, no link is provided 😢
Please check the description box.
Only for 1 user? How about multiuser?
User = Ali, abu, aida & farah.
Their task :
1) Check in
2) Break Out
3) Break in
4) Check Out
5) Total hours
where is the link to download
Link is available in the description box. Let me know if you face any issues. Thanks!
can u please share the password to unprotect it
password : 0000
Did u get the pass?
@@RawaeaDesigner THANKS!
i need password because i want to edit
Same me