Thank you so much for this timesheet. Soo good and easy to use. I have been looking for a timesheet that I could simply adapt without spending hours constructing one!. Thank you.
@@PKAnExcelExpert I have one question that if time out for the following day..its getting an error "You can update the time for today only" could you help me to this..thanks a lot
I found this template very much useful. I have an query - we work in US shift where our login time and logout time are in different dates, how can this applied in this template. I request you to reply and suggest
Hi. Pk it is nice template useful not only for time recorded. We can use in multiple purposes So,sharing macro vba code used of time update will much useful. Kindly expedite
i've created a similar file following the method, just i put dates on same row and all employee name on same column (just for documenting only in and out time). But it is not working. every time i tried to click on the "update time" it shows "You can update the time for today only". if i remove the line from modules, other functions work. can you help me?
You can consolidate it using file manager in PK's Utility Tool. Please watch below video: th-cam.com/video/ZBPaRMHXSpw/w-d-xo.html Also watch below data consolidation video: th-cam.com/video/lBuiz4VGDzA/w-d-xo.html
Hello. How can I change the date to add one on the day? For those who is having night shift they cannot use the same day? Help please. Btw, great job on the macro. Thank you.
Hi Guruji, can you help out how to identify the between dates for the given dates in excel... If I give from date and to date in one row; can system gives out put of between dates in rows? Please Help, awaiting for your response. Thank you
Sir ek question hai ?? Mare pass 4 sheet hai usme se mane 2 sheet delete kar diya or usme mane work kiya or save Kiya lakin mujje abhi wo delete sheet chiye to wo kase recovery hoga ???? Please reply sir
Hello sir good morning, Iam employe of one industry I am maintain store department please sir tell me how to mentain store by department wise like.. Electrical, Mechanical, Lab and cleaning department wise inward-outword and with using simpe format please 🙏 sir make this templet video
Hi brother! I am a businessman & sells goods in offline mode. I always required to have a track on the sale price of items sold on Flipkart and amazon and compare it with my products price😞. But the problem is, it is not possible to compare all the products' prices daily. So please create a VBA code which can enable we users to extract prices of specific items sold on Amazon and Flipkart with refresh button brother 😣
How to joint this excel with shit time, to know late early log out, limit break time at particular hour example launch break 1 hour,total working hours 8 hours ....Display less than 8 hours
My dates are put horizontally , If sh.Cells(rng.row, 1).Value Int(Now) Then MsgBox "You can update the time for today only", vbCritical Exit Sub End If this code are not wroking
If you want to skip the date stuff, and skip his coloring go to 9:18
Much appreciation for this video its amazing
Thanks for that!
Thank you so much for this timesheet. Soo good and easy to use. I have been looking for a timesheet that I could simply adapt without spending hours constructing one!. Thank you.
Glad it was helpful!
This helped me so much for my documentation!!! Thank youuuuuuuuuuuuuuuuuuuuuuuu
Most welcome
Wonderful timesheet, and you explain wonderfully too. Thank you!
You are so welcome!
Thanks for the tutorial. Great Help for me.
Most welcome🙏
@@PKAnExcelExpert I have one question that if time out for the following day..its getting an error "You can update the time for today only" could you help me to this..thanks a lot
Amazing Planning sir
Thanks
great Job PK, Tanks
Most welcome
@@PKAnExcelExpert weekly Time sheet : th-cam.com/video/usAwcaPnr50/w-d-xo.html
Thanks a lot, a very useful video
Thanks for your valuable feedback🙏
weekly Time sheet : th-cam.com/video/usAwcaPnr50/w-d-xo.html
Which employee sheet is best for more emplees vertical or horizontal
Hello Sir ! Good day ! Is this the new version of excel ? Because I can't see any developer tab on my end .
Watch the below video to learn how to enable the Developer tab in Excel
th-cam.com/video/q8AZ2TGbY7M/w-d-xo.html
weekly Time sheet : th-cam.com/video/usAwcaPnr50/w-d-xo.html
I found this template very much useful. I have an query - we work in US shift where our login time and logout time are in different dates, how can this applied in this template. I request you to reply and suggest
Great 👍
Thank you! Cheers!
Nice work
Thanks🙏
weekly Time sheet : th-cam.com/video/usAwcaPnr50/w-d-xo.html
Thanks for thats video, who can I change employees name?
Hi. Pk it is nice template useful not only for time recorded. We can use in multiple purposes So,sharing macro vba code used of time update will much useful. Kindly expedite
weekly Time sheet : th-cam.com/video/usAwcaPnr50/w-d-xo.html
Thank you so much
Most welcome
Wonderful but how I will add employees in this sheet as a list so it will update according to employee
Sir do you offer Excel course with lifetime access?
weekly Time sheet : th-cam.com/video/usAwcaPnr50/w-d-xo.html
VIDEO STARTS AT 3:03
i've created a similar file following the method, just i put dates on same row and all employee name on same column (just for documenting only in and out time). But it is not working. every time i tried to click on the "update time" it shows "You can update the time for today only". if i remove the line from modules, other functions work. can you help me?
How do you format the date again around 4 mins, do get the actual date
Great instruction. Could you also show how to consolidate all different employee's time sheet in to one combine excel file. Thanks
You can consolidate it using file manager in PK's Utility Tool. Please watch below video:
th-cam.com/video/ZBPaRMHXSpw/w-d-xo.html
Also watch below data consolidation video:
th-cam.com/video/lBuiz4VGDzA/w-d-xo.html
weekly Time sheet : th-cam.com/video/usAwcaPnr50/w-d-xo.html
practice file is not free?????????????????????????
Hello. How can I change the date to add one on the day? For those who is having night shift they cannot use the same day? Help please. Btw, great job on the macro. Thank you.
I will add this in the next version
How can we make this work on office excel 365? I was able to make it work, however it's not working on office 365
Hi! I tried opening the file but it says that it's corrupted.
Hi PK, Video quality is very low, we can't able to see clearly
Try to select HD quality
weekly Time sheet : th-cam.com/video/usAwcaPnr50/w-d-xo.html
Maxime your computer screen from the video option to maximize. Or if you have big TV, Make your TV to see your computer videos on the TV.
Amazing
Thanks
Can you make video about vba application security
Can we get entire data in an other sheet ?
Yes we can
Hi Guruji,
can you help out how to identify the between dates for the given dates in excel...
If I give from date and to date in one row; can system gives out put of between dates in rows?
Please Help, awaiting for your response. Thank you
weekly Time sheet : th-cam.com/video/usAwcaPnr50/w-d-xo.html
Sir ek question hai ??
Mare pass 4 sheet hai usme se mane 2 sheet delete kar diya or usme mane work kiya or save Kiya lakin mujje abhi wo delete sheet chiye to wo kase recovery hoga ????
Please reply sir
weekly Time sheet : th-cam.com/video/usAwcaPnr50/w-d-xo.html
Hi PK,
Please create a video for splitting PDF in customised page's, using Excel PDF.
Ok soon
Sir please show how to add employe name and how to lock cells to avoid manual entry of time only they should enter through the button.
will add this feature in next version
what if they leave after first half of the day
This sheet not use Multiple Employee Name and attendance status rel time please add multiple users
Please see our another product at below link:
th-cam.com/video/PnZrH-fvMto/w-d-xo.html
Thanx
Welcome
weekly Time sheet : th-cam.com/video/usAwcaPnr50/w-d-xo.html
Hello sir good morning, Iam employe of one industry I am maintain store department please sir tell me how to mentain store by department wise like.. Electrical, Mechanical, Lab and cleaning department wise inward-outword and with using simpe format please 🙏 sir make this templet video
weekly Time sheet : th-cam.com/video/usAwcaPnr50/w-d-xo.html
Sir Please share macro coding
Download link is given in video's description box
Hi brother!
I am a businessman & sells goods in offline mode. I always required to have a track on the sale price of items sold on Flipkart and amazon and compare it with my products price😞. But the problem is, it is not possible to compare all the products' prices daily.
So please create a VBA code which can enable we users to extract prices of specific items sold on Amazon and Flipkart with refresh button brother 😣
Yes sir, can you create a VBA code for it to extract prices in excel.
It will be very much useful.
Please refer the below video for your requirements-
th-cam.com/video/0JHbb5-elMU/w-d-xo.html
@@PKAnExcelExpert sir this VBA is not working. Don't know why. I copied and pasted the code but didn't work. Can u explain, why is it so ?
weekly Time sheet : th-cam.com/video/usAwcaPnr50/w-d-xo.html
How to joint this excel with shit time, to know late early log out, limit break time at particular hour example launch break 1 hour,total working hours 8 hours ....Display less than 8 hours
password kaya he
My dates are put horizontally ,
If sh.Cells(rng.row, 1).Value Int(Now) Then
MsgBox "You can update the time for today only", vbCritical
Exit Sub
End If
this code are not wroking