𝐀𝐓𝐓𝐄𝐍𝐃𝐀𝐍𝐂𝐄 𝐒𝐇𝐄𝐄𝐓 𝐰𝐢𝐭𝐡 𝐂𝐇𝐄𝐂𝐊 𝐢𝐧 𝐚𝐧𝐝 𝐂𝐇𝐄𝐂𝐊 𝐨𝐮𝐭 𝐓𝐢𝐦𝐞 / 𝐓𝐢𝐦𝐞 𝐢𝐧 𝐚𝐧𝐝 𝐓𝐢𝐦𝐞 𝐨𝐮𝐭 / 𝐎𝐯𝐞𝐫 𝐓𝐢𝐦𝐞
HTML-код
- Опубликовано: 1 окт 2024
- If you need an easy and perfect way to track your employees’ working hours while ensuring that they get paid correctly - you need an employee attendance sheet. An attendance sheet template will save your time and money when tracking the hours of your team
Maintaining attendance sheet is the easiest way to do but it needs certain things to be changed every month. In today’s video you will learn how to make a fully automated attendance sheet which will be fully controlled of managed by drop downs and will not need any update if month or year changes.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 𝐏𝐥𝐞𝐚𝐬𝐞 𝐣𝐨𝐢𝐧 𝐭𝐡𝐞 𝐂𝐡𝐚𝐧𝐧𝐞𝐥 𝐌𝐞𝐦𝐛𝐞𝐫𝐬𝐡𝐢𝐩 𝐭𝐨 𝐃𝐨𝐰𝐧𝐥𝐨𝐚𝐝 𝐭𝐡𝐞 𝐅𝐢𝐥𝐞:
𝐉𝐨𝐢𝐧 𝐭𝐡𝐞 𝐜𝐡𝐚𝐧𝐧𝐞𝐥 𝐌𝐞𝐦𝐛𝐞𝐫𝐬𝐡𝐢𝐩 𝐟𝐫𝐨𝐦 𝐭𝐡𝐞 𝐥𝐢𝐧𝐤 𝐛𝐞𝐥𝐨𝐰:
/ @office-monk
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 𝗙𝗶𝗹𝗲 𝗟𝗶𝗻𝗸: 🅾🅽🅻🆈 🅵🅾🆁 🅲🅷🅰🅽🅽🅴🅻 🅼🅴🅼🅱🅴🆁🆂
docs.google.co...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
#attendance #dailyattendance #employeeattendance #attendanceregister #attendancesheet #attendancetracker #studentattendance #attendence #automaticattendancesheet #automatedattendancesheet #automaticattendence #automaticattendance #corporateattendancesheet #attendanceinexcel #dailyattendanceinexcel #employeeattendanceinexcel #attendanceregisterinexcel #attendancesheetinexcel #attendancetrackerinexcel #studentattendance #automaticattendancesheetinexcel #automatedattendancesheet #automaticattendenceinexcel #automaticattendanceinexcel #corporateattendancesheetinexcel #OfficeMonk #Excel #AdvancedExcel #advancedexceltraining
Topics Covered
Attendance
Daily Attendance
Daily Attendance in Excel
Employee Attendance in Excel
Attendance Register in Excel
Attendance Sheet in Excel
Attendance Tracker in Excel
Student Attendance in Excel
Corporate Attendance Sheet in Excel
Attendance in Excel
Automatic Attendance Sheet in Excel
Automated Attendance sheet in Excel
Automatic Attendance in Excel
How to make attendance sheet in Excel
How to make attendance sheet in Excel
How to make automatic attendance sheet
How to make corporate attendance sheet
How to make automated attendance sheet
This formula enter =IF(H6="Yes",IF(J6="",NOW(),J6),"") Error is "There are one or more circular reference where a formula refers to its own cell either directly or indirectly. This might cause them to calculate incorrectly. Try removing or changing these references, or formulas to different cells". Please help me out execute the formula correctly.
Go to file Tab on top, just before, Home,
Now go to formulas. In Formulas you will get the option of iterative calculations. Do minimum value as 1 and maximum value as 100. If you are using windows, follow this process. In case you are using MacBook, please let me kow, process will be different
after a lot of videos on RUclips, I got to the right place where got all the solutions...
Hello sir thanks for the detailed videos of yours. one suggestion if possible then please make it a video in a hurry I really need
Suggestions for features like...
In the Above Heading Should Be place where Name Of the Company
1) Let the User define holidays as you already included i saw your videos that's great My Work Needs this feature
2) One click Reset Months and jump on the next month manually and save it as well Included as well
3) Check In Check Out Features let the user decide the time for check-in and out to calculate O.T basic working HR is 8hr
4) Attendance Sheet With These Features - Present, Absent, Half Day, Holiday, Paid Leve, Half Paid Leve, Seek Leve
CALCULATION PART
4) BS Salary Calculation, PF ESI Deduction, and Late patently deduction, fine, Other Deduction Put Manully, Add Bonus Manually
And One more thing Advance Payment of that particular staff After calculation made end of the month.
5) Make a separate sheet for check in check out calculations For O.T And 2nd sheet is for the Attendance Sheet
6) After Calculation generate salary slips for staff and a master sheet for the month of all staff salaries for senior to recode all data in one sheet
Is it possible to make this type of Excel with the above features then please make it a single video I'm looking forward..!
I will try to come up with such format. 😊
@@Office-Monk I have already subscribed and bel ON... hope to see this In future...sir if you make this possible on Excel with this above features then you saved lot people's money on such apps where collating with us....in that case I will do for you as well in the form of some donation if available in your channel to support you....
I will be happy to see the video with this feature included in it. I have seen many videos but this is different. Kindly share with me when you come up with this kinda video. Thanks
Sure
my company works in 3 shifts(US, AUS, UK) and when an employee starts his/her shift , entry is made using ctrl+; & ctrl+shift+; , and similar thing is done when he/she takes break (2 times 30minutes in one day/shift) & also when completing day(8 hours). so doing 7:30 work in a continuous will make one day. (here us(night) shift person logs in @ 8 pm on a day and leaves @4 am next day. Anything above 7:30 is counted as Overtime and added in salary at overtime rate which is specified. Can you please make video showing how to make such dashbaord or calculation sheet.PLEASE PLEASE
Hi, why is that whenever I type in =IF(H6"",NOW(),H6),"") it doesn't show that the formula is correct on my end? But when I type in only =IF(H6"",NOW(),H6) it goes through? How do I instantly close the bracket after "" ? Thank you!
=IF(H6="",NOW(),H6),"") My formula
=IF(H6"",NOW(),H6),"") Your formula
Check minutely what mistake are you doing. If you re not able to identify the mistake, drop me a message.
@@Office-Monk Thanks for responding so quickly, I've tried to do it again it still doesn't go through. Whenever I type in the "") at the end, it doesn't turn to 0.
Have you changed the iterative calculations?
@@Office-Monk What is that? I'm sorry this is my first time using EXCEL sheet.
Please message me on my Instagram
I use Check-in Time and use same cell reference but It will not show the time automatically First I need to check Yes Than I need to Go on Check in cell and hit enter then I show the time moreover when I again delete Yes from f6 and I select yes again I need to Enter
what should I do
Remove the Column from where you have to select Yes. Directly put the time in the cells
@@Office-Monk Sir I use the Other way in which I go at option setting then Under CalculatIon options, check the box for Enable iterative calculation after that I apply same formula
I want to confirm that is this way OK like when I close file time i punch will remain the same it will not change
@@sidramustafa8711 enable iterative calculations and put maximum as 1
@@Office-Monk Sir Maximum number of iterations is 100 and Maximum Change:0.001 What column
should need to be 1
@@sidramustafa8711 Maximum number = 1
Maximum Change 0.001
Please for those of us still using the 2016 Excel, we can't access the "Style=Classic" part of the Conditional formatting/New rule part of the Functions. could you please give a different approach to that?
Option of Classic is only in MacBook. Window users will be diverted to next step, that is, use a formula to determine which cells to format
Thank you so much for this tutorial 💛
Most welcome April 😊😊😊
Surprisingly, I've also created a same sheet just like yours for my office! But, Can you make a tutorial on: Individual Employee monthly attendance report from this sheet?
I've tried several methods, but I failed. Can you help?
That's great to hear Champ. I would love to see the several methods in which you tried to create the report for individuals.
MY CHECK IN AND CHECKOUT TIME IS COMING STANDARD 12.00 am IN ALL CASES. wHAST WILL BE THE ISSUE AND WHEN I PUT FORMULA, IT GIVES ME CIRCULAR REFERENCE FOR CHECKIN AND OUT TIME
You must not have enabled "Use iterative calculation".
Only reason you are getting this challenge. Please msg me in my Instagram. I will brief you how to overcome the issue.
OfficeMonk 27
Sir Is =IF(F6="Yes",IF(H6="",NOW(),H6),"") me kiya error aa rha hai please guied me
Have you changed the format to Time format ?
Send me you file. Let me review what's the challenge.
My mail id is vijaymuukh@gmail.com
How can i do that in google sheet. formula for check in time. i follow it but it always error
There is an option of "iterative calculation" , do it 100
I applied this now function in the check in time cell but the value of time will be changed if I run another cell of check in time or check out time , how can we find the actual time for this situation
How can we fix the now function ( one time time is filled then no changes in this time )
Go to File Tab, on the left hand side you will get the option of Formulas. Click on Formulas, now come to right hand side, enable iterative calculation. Do Maximum iterations as 100
Google drive link is not working. Could you please share the file with me?
docs.google.com/spreadsheets/d/1a9x2Y3IUluiiH8-6rLhmVAP23HOsMrtV/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
Check in and out is perfect. The only thing missing is what you can't use a scanner, so the person just scan a card when come and go
Hahahahaha. Very true. Let's see when and how I come up with the format in which we can just scan QR code on id card and the entry is done
actuallu ye mere liye bhot help ful hai i want mein sheet bnau so that please help
Why the time for check in/out always auto update according to the latest inputted time? Can you explain to solve the issues?
Click on File tab on top, extreme left hand side. Go to formulas, Enable iterative calculation. It will be showing 100, do it 1
@@Office-Monk thank you for your help. I already followed your instructions but still the time changed.
vijaymuukh@gmail.com
Please send me the format
Ur video are easy to understand and you work hard for this. Great work. But sir there is a request, plz explain the formulae when applying.
Noted
I NEED THIS SHEET CAN SHARE IT WITH MEE
Hi Shivam,
You can join the Channel Membership to download this format
@@Office-Monk how can I get it
@shivamtiwari-sr9po below is the link to join the Channel Membership. Once you join the Channel Membership drop a mail on
vijaymuukh@gmail.com
ruclips.net/channel/UCBz4_fNn1dN4IiS3KWleoKQjoin
There are more cicular references where a formula refers to own cell either directly or indirectly can you suggest
Go to File on extreme left hand side, thn go to Options, in Options you will get Formulas. In Formulas you will get the option of Calculation. You will get the option of Enable iterative calculations. You will see 100 over there. Do it 1 and click on Ok. Now you can use your Circular References very easily
after complete the time formila, the check in time have no number
Go to File on extreme left hand side, then go to Options. In Options you will get Formulas. In Formulas you will get the option of Calculation. You will get the option of Enable iterative calculations. You will see 100 over there. Do it 1 and click on Ok. Now you can do the entries and time will feature automatically.
This video is really helpful, thank you so much sir!
Note: The template available in the description is incomplete. It would be helpful if you could attach a link of complete sheet in the description. ❤
docs.google.com/spreadsheets/d/1uU7kKw-p7udk11DiKFORLkHuoyUKqcOD/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
It's deleted pls share again
@@palakbhurrak4381 docs.google.com/spreadsheets/d/1a9x2Y3IUluiiH8-6rLhmVAP23HOsMrtV/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
There is error in google sheet file can you reshare it
Please drop me a line on
vijaymuukh@gmail.com
Why doesnt my validation feature show? When i select Data validation it tells me add new rule
It will show, Add new rule. Whatever rule you want to apply, you will have to select from there. Ecxel of MacBook and Windows are bit different
@Office-Monk thats the problem, mine doesnt show the rules, it just brings Add rule but not the rules to select from it. Am using windows
vijaymuukh@gmail.com
Please share couple of pictures. Let me see what's the challenge you are facing and I will surely come up with something concrete
How do you close bracket example "")
Double inverted Commas "" are for blank and if I put Bracket after it, means I might have used iferror or some other criteria.
hello sir VLOOKUP formula put nh horaha hai kya aap koi help kr sakte hai
Kya issue aa raha hai ? Aap apna file mail kar sakte ho toh please mail lar do, main check kar lunga.
vijaymuukh@gmail.com
How to add in and out time mannually
Delete 1st 2 columns of Yes (In and out). Delete all the formulas of in and out time. Now you can do manual entry
SPREADSHEET ALREADY DELETED...PLS REUPLOAD
docs.google.com/spreadsheets/d/1sLSpJyejpwpHaVWHpPDLY19cO1hPzgeo/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
thanks a lot for the tutorial. its helps a lot.
Thank you so much for loving the video and getting connected with the Channel 😊😊😊
Please share sheet sir
Were you not able to find download link in the description box?
@@Office-Monk NOT WORKING
Please share your mail id
Helpful information 👍👍👍👌👌👌
Thank you so much 😊
good one thanks
Thanks a lot for loving the video and getting connected with the Channel 😊
Good
Thanks a lot 😊
👍
Thank you so much 😊
thanku
Thank you so much for loving the video 😊😊😊
Hi there, thank you so much for sharing this. I badly need this for my team. Can you share the file with me?
Link of the file is in description box. You can download it
@@Office-Monkbro, the file was deleted. 😢
Drop me a mail on vijaymuukh@gmail.com
@@Office-Monk alright. Thanks bro!