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.
زبر دست بھائی، بہت اچھا. ایک شیٹ بنانا سیکھا دیں کہ ٹائم کیپنگ شیٹ کو اٹینڈنس اور سلیری شیٹ سب کو کیسے ایک ہی میں بنائں گے؟ کہ اگر کوئی سٹاف 3 دن لیٹ آتا ہے تو اس کی آٹومیٹک ایک لیو لگ جائے. جو کہ ٹائم کے ان آوٹ کرنے سے اس کی اٹینڈنس لگے. ایسی ایک مکمل شیٹ بنانا سیکھا دیں. شکریہ
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 🙏
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
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?
=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 🙏
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
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 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
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.
=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
धन्यवाद सरजी,मुझे भी पे-रोल बनाने मे कुछ दिकते आ रही है,क्यो की मेरी ऑफिस का पे-रोल का फॉरमॅट कुछ अलग है क्या आप मेरी हेल्प कर सकते है? और कर सकते हो मै किस प्रकार आपसे कैसे कॉन्टॅक्ट हो सकता है.
Aaj tak ka best vedio really
Bahut hi ache se samjaya thanks
Very useful and fantastic method thanku sir
अच्छे ट्यूटोरियल के लिए धन्यवाद
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
bahut ache samjaya sir thank u sir
Hi thank you for your simple & good tutorial
Thank you very much Guruji, you are awesome, really wonderful.
Very very good to learn new things.
زبر دست بھائی، بہت اچھا. ایک شیٹ بنانا سیکھا دیں کہ ٹائم کیپنگ شیٹ کو اٹینڈنس اور سلیری شیٹ سب کو کیسے ایک ہی میں بنائں گے؟ کہ اگر کوئی سٹاف 3 دن لیٹ آتا ہے تو اس کی آٹومیٹک ایک لیو لگ جائے. جو کہ ٹائم کے ان آوٹ کرنے سے اس کی اٹینڈنس لگے. ایسی ایک مکمل شیٹ بنانا سیکھا دیں. شکریہ
Bahut zabarjast sir
Sir awesome information. You are Great
Nice Sir, So Amazing.
Bahut achha
Thank you so much sir
How to calculate half day sir
Thanks informative video
Find out DA 15% on basic salary only for those who belong to HR department and 0 for other.sir please solve the question
Thank u sir 🔥❤️
thanks bro. Its helpful
Excellent and simple
👍 great
Simple and effective. Love it.
Thanks you sir for tutorial, but one option add salary sheet my option add over time(OT) plz solve my query,
It's too good thank you so much 😊
thank you sir
sir alag alag dates ki salary kese calculate krenge is par bhi koi video bnao
You r good sir
Sir àapka video very nice aap to formula Ka sheet bhi provide kr dete hai other log Nahi karate hai
Thank you🙏.. Sir!
Great👍..
Please sir.. Upload a Auto PDF generated in bulk "payslip" & how to send bulk payslip through whatsapp on employees?
Excellent sir
THANKS A LOT SIR
Awesome one 👌👌👌
Mind blowing sir🥇🥇🥇🥇🥇🥇
wonderful and good job
Very nice
Superb..... 👍👍👍
Intelligent 👍🏾
GOOD VIDEO
Amazing sir
attendance make need sheet with time in and timeout and overtime and Late then you make Present and absence then you make monthly Salary.
Thanks Sir
Thank you
Thanks Sir !
I kindly request you , to show us that how year can be made automatic , you have used midcell formula,kindly brief us.
Thanks.
Dear Sir
Heading ke saath jo Month and Year (January 2020) mein jo formula lagaye hain please wo bataiye
Thank you
Thank u sir ..
sir company me kis tarah hota hata hai ek seriese banaye
Sir plz teach us how to animate in micro media flash 8.sir plz
सर अटेंडेंस में ओवर टाईम का या डबल हाजिरी या डेढ़ा हाजिरी का क्या फॉर्मूला होगा प्लीज इसका मार्गदर्शन करें
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 🙏
Nice
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 ले ली है तो कैसे निकाले
Dear sir.
Type kare aur Surcheble drop down list banti jaye without right click. Please espar koi video banaiye.
Please clear the confusion of - Back button
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
Fully automatic bonafide certificate sheet kaise banaye pls bataye
Thanku sir
Pf esic format banaiya sir ji
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
❤️
sir my laptop me window 10 h kya is me formulas kese lgege.please btayen
Sir is attendance sheet me v lookup formula se ek sath id se uski all details kese chek kare
Sir, if hme 24 January se 23 February tk ki attendance sheets bnani h to date ka kya formula hoga pls reply.
Sir which version apply this formula please reply
SIR Agr aap ki sheet me half day ki attendence lagani ho to kese lgai. please coment me btayen sir.
Sheet formula copy explain please
Same Sun mon ... Jo likhe hai waisa humko mobile se likhana k kis option me jayenge
Itni simple cheezo ke liye bhi itne formula's use kiya hai sir apne toh 🤣
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?
अगर मैं ग्रेड का sum करना चाहूँ तो क्या फॉर्मूला यूज़ होगा।
उदारहरण ग्रेड a+b+a= a
Please tell me sir how to make weekly wages report
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
=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 🙏
With time attendance sheet ban sakti hai.
Guru sir, January 2020 apna js cell ma write Kiya wo working correctly Kam Nahi karta ha...
Mobile se same ban jayega
=mid(cell("filename"B1),find("]",cell(Filename "B1"))+1,255&" "&2020
Ye formula kam nahi kar raha hai sir
Ji, February mein bhi 29feb k baad 1 & 2 aa rahi hai
Sir jo january pa long wala formula lagya usko smjha da kasya lagna
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??😢
Sir isme mid wala formula samjaye pls
Sir maine job January month ka present Dal ta hun,tabhi February month pe January month ka present show karta he
Nice sir but ek questions hai actual salary nhi nikal rhi mai formula bhi use kar rha hu
share the formula?
Mera bhi nahi nikal raha hai
Sir aise main apsent days one year main kitne days apsent hai
Please explain sheet name formula properly
Hello sir mera newspaper ka shop hai mere newspaper customer ka automatically excel account maintenance kaise kare koi tarika bataye
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
What can be the formula if we want to calculate employees rate per hours ?
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
Same date value ko ek sath aap kise fixed kiya, uski shortcut key kya hai sir
Data entry ka bhi
Assalam-o-Alikum,
Hamari company me 21 se new month start hota hai aur next month ki 20 ko end hota hai, us k liye kiya karien?
just put the 21 in place of 1
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
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.
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
What if the count of people who we are counting the salary for keeps changing?
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) sir ye formula kasy banta zara is ko explain karden kindly
Mid vale formulas me file name konsa daln hai sir
Discription me jo formulas hai usme file ka name konsa dalna hai
=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
धन्यवाद सरजी,मुझे भी पे-रोल बनाने मे कुछ दिकते आ रही है,क्यो की मेरी ऑफिस का पे-रोल का फॉरमॅट कुछ अलग है क्या आप मेरी हेल्प कर सकते है? और कर सकते हो मै किस प्रकार आपसे कैसे कॉन्टॅक्ट हो सकता है.
hello sir mene sabhi sheets bna li h lkn oct or feb me error value show kr rha h please btaye ye kese hatega
Sir excel sheet can’t useable in google sheet. Any solution.