How to make an automated attendance sheet in excel | Attendance and salary sheet in excel in hindi
Vložit
- čas přidán 3. 04. 2021
- How to make an automated attendance sheet in excel | Attendance and salary sheet in excel in hindi.
#attendancesheet #salarysheet #msexcel #computergyanguruji
Practice file download:drive.google.com/file/d/1DUq-...
Formula:- =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&" "&2020
Our second channel
/ computergurujitechnical
www.amazon.in/shop/computergyanguruji
Follow us on
instagram
/ computergyanguruji
Twitter
/ c_g_guruji
Facebook
/ computer-gyan-guruji-1...
MS Excel Videos
• Hindi English Dictiona...
MS Excel for Beginners
• MS Excel Tutorial for ...
Excel VBA
• Excel VBA
MS Word
• MS Word
MS PowerPoint
• MS Power Point
MS Access
• MS Access tutorial for...
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Notepad & HTML
• Notepad complete tutor...
CSS
• Introduction to CSS | ...
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Reasoning
• Reasoning
Airthmatics
• Airthmetic
Simple and effective. Love it.
Sir awesome information. You are Great
Aaj tak ka best vedio really
Bahut hi ache se samjaya thanks
It's too good thank you so much 😊
Thank you very much Guruji, you are awesome, really wonderful.
Very very good to learn new things.
bahut ache samjaya sir thank u sir
Very useful and fantastic method thanku sir
wonderful and good job
thanks bro. Its helpful
Hi thank you for your simple & good tutorial
Absolutely, I did not make a mistake to subscribe your channel. I think you are the one from who I can learn and gain effortlessly because your way of teaching is so exciting and clear.
GREAT REPLY
Mind blowing sir🥇🥇🥇🥇🥇🥇
Awesome one 👌👌👌
Excellent and simple
अच्छे ट्यूटोरियल के लिए धन्यवाद
Thank u sir 🔥❤️
Nice Sir, So Amazing.
Thanks sir for very useful video of attendance
.
Will you pls show us 9:00 AM to 5:30 PM working where 0:30 mins for lunch time and if worked Overtime this will be of gr8 help as I prepared it myself but it has some limitations
Pls sir 🙏
Thanks informative video
Bahut zabarjast sir
Thank u sir ..
Thank you sir
Superb..... 👍👍👍
Amazing sir
Excellent sir
Find out DA 15% on basic salary only for those who belong to HR department and 0 for other.sir please solve the question
THANKS A LOT SIR
Intelligent 👍🏾
Great Video
You r good sir
Thanku sir
What if the count of people who we are counting the salary for keeps changing?
👍 great
Bahut achha
Thank you so much sir
How to calculate half day sir
Sir which version apply this formula please reply
sir company me kis tarah hota hata hai ek seriese banaye
Thank you
=MID(CELL("filename",B2),FIND("]",CELL"filename",B2))+1,255)
Sar Google sheets ke liye yah formula kam nahi kar raha hai #value aa raha hai sar Google sheets ke liye eisa formula bataye 🙏
Sir plz teach us how to animate in micro media flash 8.sir plz
GOOD VIDEO
Very nice
Thanks you sir for tutorial, but one option add salary sheet my option add over time(OT) plz solve my query,
❤️
Thank you🙏.. Sir!
Great👍..
Please sir.. Upload a Auto PDF generated in bulk "payslip" & how to send bulk payslip through whatsapp on employees?
Please clear the confusion of - Back button
Sir àapka video very nice aap to formula Ka sheet bhi provide kr dete hai other log Nahi karate hai
Dear Sir
Heading ke saath jo Month and Year (January 2020) mein jo formula lagaye hain please wo bataiye
Thank you
sir alag alag dates ki salary kese calculate krenge is par bhi koi video bnao
How to calculate overtime for the employees who comes in shifts, e.g. time in Monday 2:00 p.m. and time out is Tuesday is 1:30 a.m. where working hours are 9 hours a day.
What can be the formula if we want to calculate employees rate per hours ?
sir my laptop me window 10 h kya is me formulas kese lgege.please btayen
With time attendance sheet ban sakti hai.
Respected Sir,
I want to make student attendance sheet with automatic update of time and date by clicking in single cell of excel sheet. For example at arrival of a student when I will click in cell in front of coming student that cell time must be shown as well as "p " for present and date at same time. Is it possible or not?
Nice
Hello Sir,
Greetings!
My employees salaries are calculated from 21st to 20th of every month. So how i can put the date formula.
Ex:- 21st June 2021 to 20th July 2021
Same here
@@nikhilkapoor82 You need to create a roster starting on the day that your first wage was paid [for example, from 21 to 21] and use the same calculation as for the months. 1 to 30 or 31
Sir, When I shift this excel sheet into googel sheet., No months are visible and i am not able to work..what to change in this??😢
Thank you Sir for sharimg. Need help in creating monthly bills for individual members of my society. Please share ur personal chat id so that I can share my file
Sir, if hme 24 January se 23 February tk ki attendance sheets bnani h to date ka kya formula hoga pls reply.
How to count the no of students present in running date Sir
Pf esic format banaiya sir ji
अगर मैं ग्रेड का sum करना चाहूँ तो क्या फॉर्मूला यूज़ होगा।
उदारहरण ग्रेड a+b+a= a
Fully automatic bonafide certificate sheet kaise banaye pls bataye
Sir alag alag sheet na use karte hue ek hi sheet mein drop-down laga ke wahi ek hi sheet me all months ke report data store ho aisa kuch bataiye
SIR Agr aap ki sheet me half day ki attendence lagani ho to kese lgai. please coment me btayen sir.
Please tell me sir how to make weekly wages report
Sir is attendance sheet me v lookup formula se ek sath id se uski all details kese chek kare
=indirect ("'"&$A4&"'!d3:d3") sir Maine ye formula aaply kiya hai data extract krne from other sheet.. but sir other columns mein jab formula drag krna chahata hoon toh nhi horaha plssss sir kindly guide me.. mjhe har column bar bar formula lagana pardhra I want to drag it at once
Dear sir how we calculate overtime give each day 2 hours but here all in text P L H words
Dear sir.
Type kare aur Surcheble drop down list banti jaye without right click. Please espar koi video banaiye.
Sir isme mid wala formula samjaye pls
Same date value ko ek sath aap kise fixed kiya, uski shortcut key kya hai sir
hello sir mene sabhi sheets bna li h lkn oct or feb me error value show kr rha h please btaye ye kese hatega
Sorry sir but I am facing problem with salary payble when I divided salary with month days it Showing wrong pls help
Sir jo january pa long wala formula lagya usko smjha da kasya lagna
Sir agar kisi employee ka half day hai to use kaise calculate karenge uske liye kya formula use kar sakte hai?
nice, upload soon
सर हमे परे साल का एक साथ टोटल दिखाना है कि किसने कितनी Leave ले ली है तो कैसे निकाले
Sir isme jo starting m date ke second cell m jo formula fix kiya h vo kaise kiya plz btayie vo clear nhi ho rha
Sir date value funnse maine ek sheet banayi hai with drop down list . But how can change calander year to financial year in date value fun. As mujhe apr 21 to march 22 tak ki sheet banani hai. Plz help
Good after sir how we can lock the year and month when we change the the month or year first written attendance comes again and again
Sheet formula copy explain please
sir jb me conditional formating lgata hu to error comments atta h please guide kese theek karen,
Data entry ka bhi
Same Sun mon ... Jo likhe hai waisa humko mobile se likhana k kis option me jayenge
Hello sir mera newspaper ka shop hai mere newspaper customer ka automatically excel account maintenance kaise kare koi tarika bataye
Mobile se same ban jayega
Sir jb hum actual salary calculate kr rhe hai to DOM le rhe hai to ans error aa rha hai q?
زبر دست بھائی، بہت اچھا. ایک شیٹ بنانا سیکھا دیں کہ ٹائم کیپنگ شیٹ کو اٹینڈنس اور سلیری شیٹ سب کو کیسے ایک ہی میں بنائں گے؟ کہ اگر کوئی سٹاف 3 دن لیٹ آتا ہے تو اس کی آٹومیٹک ایک لیو لگ جائے. جو کہ ٹائم کے ان آوٹ کرنے سے اس کی اٹینڈنس لگے. ایسی ایک مکمل شیٹ بنانا سیکھا دیں. شکریہ
Sir aise main apsent days one year main kitne days apsent hai
सर अटेंडेंस में ओवर टाईम का या डबल हाजिरी या डेढ़ा हाजिरी का क्या फॉर्मूला होगा प्लीज इसका मार्गदर्शन करें
Ji, February mein bhi 29feb k baad 1 & 2 aa rahi hai
#value dikha raha hai from k niche liken pr Jase aapneebataya pls tell me
Mid vale formulas me file name konsa daln hai sir
Discription me jo formulas hai usme file ka name konsa dalna hai
sir data ko kis key se fix kiya jata h
Sir agar m sheet m month ki date dalu to designation wise count mile for example, mere pas executive, supervisor, Deo, Scanner h Or mughe data consolidation hoke mile ki 2 tarik ko kon kon aya h count m next sheet p bass us din ki date dalne p
Sar =datevalue(aa1) formula karte he to problem aate he ,January 2021 kese likhe
Sir dubal duty hai ti kese karenge
i am trying the datevalue formula but it does not work every time it comes value
help please to solve
attendance make need sheet with time in and timeout and overtime and Late then you make Present and absence then you make monthly Salary.
Assalamualaikum sir
Main ye formula laga Raha hon nahi lag Raha hai
Actual salary
=Salary/Dom*working days
Enter karny par 12 araha hi
Ye kiyon employee salary 25000 hai