Attendance Sheet with Check in and Check out Time / Time in and Time out / Over Time
HTML-код
- Опубликовано: 13 сен 2024
- Attendance Sheet with Check in and Check out Time / Time in and Time out / Over Time
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.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 Please join the Channel Membership to download the file:
👇🏼 Click here 👇🏼
/ @office-monk
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 File Link: Only for Channel Members
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
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
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
thanks a lot for the tutorial. its helps a lot.
Thank you so much for loving the video and getting connected with the Channel 😊😊😊
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
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
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.
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
Helpful information 👍👍👍👌👌👌
Thank you so much 😊
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
good one thanks
Thanks a lot for loving the video and getting connected with the Channel 😊
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!
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
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
actuallu ye mere liye bhot help ful hai i want mein sheet bnau so that please help
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.
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
thanku
Thank you so much for loving the video 😊😊😊
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
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
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
Good
Thanks a lot 😊
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
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.
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
There is error in google sheet file can you reshare it
Please drop me a line on
vijaymuukh@gmail.com
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
👍
Thank you so much 😊
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
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
SPREADSHEET ALREADY DELETED...PLS REUPLOAD
docs.google.com/spreadsheets/d/1sLSpJyejpwpHaVWHpPDLY19cO1hPzgeo/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true