I am so grateful to God Almighty and to the producer of this video, this lesson had push me a steps further while on the path of Success. Like I always maintain, Success is not a destination but rather a PATH. Again I say big thank you yaaah...
Dear Sir, I have a question if we have to find number of holidays and sundays and listing them in a column ( For example we have 5 sundays and 2 holidays, then Total off day will be 7. But how do we separate sundays and holidays in a column using the above attendance sheet ) ... I did try but I am stuck here. Hope you will find me a solutions. Thanks
The year should also have a drop-down list to choose the year and the attendance sheet changes according to the selected year and month. Overall great VDO. Teaching is good, felt that you are in front of me...
@@SahaComputer One more thing, in the Sunday and Holiday columns should be displayed as "S" and "HL" in every cell automatically, then this will be more attractive...
Appreciate Video! Excuse me for chiming in, I am interested in your opinion. Have you heard the talk about - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a great one of a kind product for getting 7000 plus project management and business templates without the normal expense. Ive heard some amazing things about it and my buddy at very last got astronomical success with it.
Thanks for reminding me my memories (back 7years from now). When I was working as Admin and I was very familiar with this attendance sheet. Thanks a lot.
You r genuis my brother .. big effort maked .. i ask about attendance .. when i put ( P,A,H) in any months . I find it the same schedule i want each month to be kept separately ..
I love this!!! It's been nine months since pandemic and I have hard time in manual entry for attendance... Browsing your vids and see what helpful tips I can find... Looking for time in and out in Excel.....
For our office we have sat and sun as weekoff. How can i insert that in formula for both days. As in video it shows only sun. Highly Appreciate your video which will be helpful for everyone. Hatsoff
How to find out,when an employee worked for more than 24 hours continuously ...I.e yesterday' day and night and again today's day...because an employee should not continue his duty more than 12 hrs ....so please clarify
Thank you for creating this easy to follow explanation. I also appreciate that it doesn't rely on outside "plug ins" that my jobs network doesn't allow.
You should check the latest video in my channel, I have uploaded complete automation on attendance where you can take attendance, manage leaves & payroll every thing is there.
Dear sir, thank you so much for sharing such useful knowledge. Your instructions are very clear & easily comprehensible. I followed your guidance step by step & succeeded in creating my own attendance sheet to be used for my class. Thank you so much. God bless.
Great!! agar tum isse better attendance sheet banana chahate ho to niche diye link click karo. th-cam.com/video/1tGSpi_4B_o/w-d-xo.html th-cam.com/video/pDGmmIhqV2Y/w-d-xo.html th-cam.com/video/6QvJ0t0L4_A/w-d-xo.html
This Tutorial is amazing. I wished the year should also have a drop-down list so that the attendance sheet changes according to the selected year and month. If possible please send it to us. thanks
Hello. Thank you very much for tutorial. It’s very helpful. I want to create an attendance for only Sunday’s with no holidays. Please can you assist me with some steps on how to do that? Thank you.
Really helpful. Thank you soo much. I need to know one more thing. Can any one help me out. If we have one more employee added after doing all this process. We need to do the same process again or is there any shortcut.
I have also taken the range upto 15. But i want to increase upto 90. My question is. I need to do the process from the start or is there any shortcut, i want to add employees to same sheet and wouldn't do the whole process again.
I have learned so much from your video! so Thank you very much!. I want to ask you about something, can you make the attendance taken in January stay only in January and not move to feb? in another words, i do not want to use clear and copy buttons, i want to change the month and get another empty cells spcifically for that month. Can you do that please!!
Hi, thanks for sharing this video, which formula other than data value I can use to select the year of my preference and not the computer system year? I appreciate your help.
Hi thanks for this awesome vid.. Here in philippines we have many kinds of holiday.. trying to set regular holidays, special nonworking holidays and special working holidays.. how do i set this in the same timesheet? with conditional formatting as well.. i'm kind of stuck. trying to copy what you do.
You can type your weekends in Weekend list and Holidays in the holiday list in the setting sheet. If you have different holiday list then you cannot do that in this sheet. But still you can do this by keeping all holiday dates in single list.
I am so grateful to God Almighty and to the producer of this video, this lesson had push me a steps further while on the path of Success. Like I always maintain, Success is not a destination but rather a PATH. Again I say big thank you yaaah...
You are very welcome
Please share a video in which can calculate half day as .5
If you want to get the total of total present including halfday, then create another column and type =Total Present+(Total Halfday /2)
Amazing.... immersed in it... realised that 30 min just flew...cos each and every second was informative..simply awesome
Glad you liked it!
Dear Sir, I have a question if we have to find number of holidays and sundays and listing them in a column ( For example we have 5 sundays and 2 holidays, then Total off day will be 7. But how do we separate sundays and holidays in a column using the above attendance sheet ) ... I did try but I am stuck here. Hope you will find me a solutions. Thanks
The year should also have a drop-down list to choose the year and the attendance sheet changes according to the selected year and month.
Overall great VDO. Teaching is good, felt that you are in front of me...
@@SahaComputer One more thing, in the Sunday and Holiday columns should be displayed as "S" and "HL" in every cell automatically, then this will be more attractive...
Appreciate Video! Excuse me for chiming in, I am interested in your opinion. Have you heard the talk about - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a great one of a kind product for getting 7000 plus project management and business templates without the normal expense. Ive heard some amazing things about it and my buddy at very last got astronomical success with it.
I have added it by my self
@@MrAram85 how
Latest Attendance Tracker Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Thanks for The Video Sir, if anyone feels like giving up on this ...it actually works
Thanks for your comment.
Thank you very much Sir.
very helpful.. You explanation is very simple for learners like me.. Superb..God bless you👍
Latest Attendance Tracker Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Thanks for reminding me my memories (back 7years from now). When I was working as Admin and I was very familiar with this attendance sheet.
Thanks a lot.
Its my pleasure!! Thanks for your comment.
You r genuis my brother .. big effort maked .. i ask about attendance .. when i put ( P,A,H) in any months . I find it the same schedule i want each month to be kept separately ..
Latest Attendance Tracker Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Thank you Sir. The clear button is very important thing to add in sheet like this. Great job
Latest Attendance Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Masterpiece................Great effort
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: th-cam.com/video/QHr-4WsQo-E/w-d-xo.html
I love this!!! It's been nine months since pandemic and I have hard time in manual entry for attendance... Browsing your vids and see what helpful tips I can find... Looking for time in and out in Excel.....
Glad you like them!
Watch this update video: th-cam.com/video/NUK8PXLfggo/w-d-xo.html
Bravo,, THIS IS AWESOME,, Great effort thannnnnnnnnnnnnnnnnnnnk u ,, u r Geniusssssssssssssssssssssssssssssssssssssssssssssssss
Latest Attendance Tracker Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Your work has being useful to me .Thanks and share more for us to learn
Glad to hear that
For our office we have sat and sun as weekoff. How can i insert that in formula for both days. As in video it shows only sun.
Highly Appreciate your video which will be helpful for everyone. Hatsoff
I will check today
Latest Attendance Tracker Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Thanks a lot for making this video. It has helped me to make an attendance sheet in the Excel.
You are most welcome
where did you get the code from?
Thank you so very much !!! very well explained I managed to do my own, thank you once again
Glad it helped!
How to find out,when an employee worked for more than 24 hours continuously ...I.e yesterday' day and night and again today's day...because an employee should not continue his duty more than 12 hrs ....so please clarify
This attendance sheet is not time based so it is clearly understood that the employee works within office hours.
This is not time tracker this is attendance tracker
thank you for sharing. I did it for mine, I save a lot of time!
You're welcome!
Great video and easy to follow! How do I change the year from 2019 to 2020?
Latest Attendance Tracker Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Thank you so much sir for explaining step by step. It's really very very helpful for the beginners. 🙏🙏🙏
It's my pleasure
Great tutorial! I have a question please, the half days are counted as whole days in the total work days column how to fix it.
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: th-cam.com/video/QHr-4WsQo-E/w-d-xo.html
Great video....exactly what i was looking for....
Latest Attendance Tracker Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Is this only for 2019? What if year changes?
@@SahaComputer My sincere love & respect to u all
Latest Attendance Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Good One, Very Impressed Presentation & took time to explain. Understood Easily
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: th-cam.com/video/QHr-4WsQo-E/w-d-xo.html
Do you have a sample code for time in, time out for employee/teachers using RFID card (tapping) badly needed pls. thanks in advance
Watch this video
th-cam.com/video/QHr-4WsQo-E/w-d-xo.html
thank you sir you are champion you explain it step by step very clearly to understand.may god bless you
So nice of you
You have explained it so well , there is no question to be asked...thanks so much and see you with new program-mes....Manohar Timothy
So nice of you
Really very helpful for my mother as she is making attendence chart for her school ! ❤️
Great, It helped. Thanks for the comment.
Thank you for creating this easy to follow explanation. I also appreciate that it doesn't rely on outside "plug ins" that my jobs network doesn't allow.
Latest Attendance Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Very nice teaching step by step, great and very helpful
Glad it was helpful!
Thank you for making it in English. This sooo helpful
You're welcome 😊
Thank you, for teaching me steps-by-steps.. for a Slow Learner like me this became so easy for me.. Thank you!
Glad it was helpful!
Informative and easy to follow. Thank you!
You are welcome!
Thanks for the Tutorial. Appreciating your great mind
Thanks for your nice comment.
you're an excel pro!!
Hi, Thanks for your appreciation. I request you to visit our channel, we have videos on different types of attendance sheet tutorials.
It is very helpful and very informative video thank you very much
You are most welcome
This taught me a lot, very easy to follow. Thank you so much!
Glad it was helpful!
THANKS FOR THE DETAILED AND SUCH EASY BRIEF
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: th-cam.com/video/QHr-4WsQo-E/w-d-xo.html
Fantastic it helped me a lot. Thank you
Thanks.
thank u so much for video
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: th-cam.com/video/QHr-4WsQo-E/w-d-xo.html
wow!!! really amazing. Thanks a lot
You are most welcome
Very nice video
I make my sheet with the help of your video
Thanks sir
Latest Attendance Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Thank you so much, very helpful.
Glad it was helpful!
Thank so much.....this one really helped me..
You're welcome!
Bravo! Very clear, was able to create my own, thank you so much :)
Latest Attendance Tracker Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Masterclass...............Thank you.
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: th-cam.com/video/QHr-4WsQo-E/w-d-xo.html
Really Good job!!! God bless you forever . It is very important for our Country( Ethiopia) factory .
Latest Attendance Tracker Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Super good teacher. Thanks for explaining in details. Appreciate it. You have kind heart. Thank you so much sir.
You can check out this video your all problem will be solved.
th-cam.com/video/NUK8PXLfggo/w-d-xo.html
Thank you! Great idea
Thanks for your comment.
Very helpful - thanks
You're welcome!
Excellent Sir
Many many thanks
This would be perfect for my organization.
You should check the latest video in my channel, I have uploaded complete automation on attendance where you can take attendance, manage leaves & payroll every thing is there.
Super video sir. Thanks a lot
Thank you sir, please subscribe our channel to get some new and more advance attendance sheet tutorial video will be added.
Thank you so much, I have successfully completed.
Excellent!
Thank you very much from Myanmar.
You are welcome
Dear sir, thank you so much for sharing such useful knowledge. Your instructions are very clear & easily comprehensible. I followed your guidance step by step & succeeded in creating my own attendance sheet to be used for my class. Thank you so much. God bless.
interested in more, click the icon for my account and get more for timeshhet and attendance. dont forget to like n subscribe
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: th-cam.com/video/QHr-4WsQo-E/w-d-xo.html
very useful tutorial tricks.. thank you bro
Latest Attendance Tracker Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Very good video thanks.
Latest Attendance Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
This is aweeeeeesome Marvellous Geniuuuuuuuuuuuusssssssssssssss Thankssssssssssssss Allot sir
You are most welcome 😊
Very nice..ty for sharing this
Latest Attendance Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Thanks you bhaiya mein to sab sikh gaya
Great!! agar tum isse better attendance sheet banana chahate ho to niche diye link click karo.
th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
th-cam.com/video/pDGmmIhqV2Y/w-d-xo.html
th-cam.com/video/6QvJ0t0L4_A/w-d-xo.html
Your teaching and video is awesome, when are you going to do stock management videos I really need one
Very soon!
Awesome video
Clear steps
Thanks
Latest Attendance Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
This Tutorial is amazing. I wished the year should also have a drop-down list so that the attendance sheet changes according to the selected year and month. If possible please send it to us. thanks
You can watch this video, there are several updates: th-cam.com/video/NUK8PXLfggo/w-d-xo.html
tqvm .... i m follow this step by step till success to complete it.
Glad to hear that.
Very important sheet for beginner's
Thanks for your comment.
it was really helpful, thanks a lot and God bless you
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: th-cam.com/video/QHr-4WsQo-E/w-d-xo.html
You're Very Detil Sir... Thank You So Much... 👍🏽👍🏽👍🏽👍🏽
Latest Attendance Tracker Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Dude u are a genius i wish to see something about automatic time and amount to pay hourly
I will make one.
Very useful, Thank you very much.
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: th-cam.com/video/QHr-4WsQo-E/w-d-xo.html
THANK YOU SOOO MUCH.
You're welcome!
Nice, thank you👍
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: th-cam.com/video/QHr-4WsQo-E/w-d-xo.html
Very good class sir
You can check out this video your all problem will be solved.
th-cam.com/video/NUK8PXLfggo/w-d-xo.html
Thanks for the wonderful information shared through this video.
Latest Attendance Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Ok thanks sir😊
Welcome
Great love it
Thanks
Very Usefull thanks
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: th-cam.com/video/QHr-4WsQo-E/w-d-xo.html
Hello. Thank you very much for tutorial. It’s very helpful. I want to create an attendance for only Sunday’s with no holidays. Please can you assist me with some steps on how to do that? Thank you.
You can use this attendance sheet, just exclude the VBA.
Really helpful. Thank you soo much. I need to know one more thing. Can any one help me out. If we have one more employee added after doing all this process. We need to do the same process again or is there any shortcut.
You can add as much employee as you want but in this tutorial we have taken the range upto 10 employees , you can take it for 100 employees.
I have also taken the range upto 15. But i want to increase upto 90. My question is. I need to do the process from the start or is there any shortcut, i want to add employees to same sheet and wouldn't do the whole process again.
Just drag down the formula with fill handle upto row 90.
Check new attendance sheet: th-cam.com/video/pDGmmIhqV2Y/w-d-xo.html
Its a great very useful work done by you.can i get this sheet for myself .
Link in the description box.
Excellent video
Latest Attendance Tracker Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
So Nice video 💝
Thanks for your comment.
Perfect video uncle jee....
You can check out this video your all problem will be solved.
th-cam.com/video/NUK8PXLfggo/w-d-xo.html
I have learned so much from your video! so Thank you very much!. I want to ask you about something, can you make the attendance taken in January stay only in January and not move to feb? in another words, i do not want to use clear and copy buttons, i want to change the month and get another empty cells spcifically for that month. Can you do that please!!
th-cam.com/video/pDGmmIhqV2Y/w-d-xo.html
th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Watch these two video series, your problem will be solved.
Will do
Thank you. it's work now
Latest Attendance Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Hi, thanks for sharing this video, which formula other than data value I can use to select the year of my preference and not the computer system year? I appreciate your help.
See video 96.
Hi thanks for this awesome vid.. Here in philippines we have many kinds of holiday.. trying to set regular holidays, special nonworking holidays and special working holidays.. how do i set this in the same timesheet? with conditional formatting as well.. i'm kind of stuck. trying to copy what you do.
You can type your weekends in Weekend list and Holidays in the holiday list in the setting sheet. If you have different holiday list then you cannot do that in this sheet. But still you can do this by keeping all holiday dates in single list.
Oh wow!! You’re amazing!
Latest Attendance Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Very helpful. Thanks for such efforts
Latest Attendance Tracker Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Nice one
Thanks
Simply outstanding
Latest Attendance Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Thank you :)
You're welcome! You can watch other attendance sheet in our channel. They are even more better.
great job sir
Latest Attendance Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Awesome..
Thanks 🤗
Thank you for this video. Very informative.
Latest Attendance Tracker Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Hi , this is very helpful, I kindly would like to know the formula for when the (P)day is for Sat & Sun? To count both
If you want to present all all days then its very simple
=countif(cell range,"P")
Thank, I'll try. If am struggling would you please assist me ?
Sure
Please, subscribe our channel
@@SahaComputer thank you, I did 😀
Just what I needed, thanks a lot
Latest Attendance Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Thank you for this.. really helpful..
Latest Attendance Video: th-cam.com/video/1tGSpi_4B_o/w-d-xo.html
Thanks for the wonderful video, how to write the module for copy sheets or where do I get the information to learn? Thank you.
You can goto our blog site, link given in description box.
@@SahaComputer thank you!
You are welcome