Main is video me bata chuka hu agar hum formule me 0.5 nahi lagate to 4 half days hote. maine formule me 0.5 isliye lagaya taki jo half days hai wo full day me convert ho jayein aur hum per day salary calculate kar payein. 4 half day matlab 2 full day second example 50 paise+50 paise+50 paise+50 paise = 2 Rupees, am i right sir,. Agar phir bhi apko meri baat nahi samajh aayi to mujhe is baat ka dukh hai. ek baar main phir se clear kar deta hu aisa maine isliye kiya taki hum per day salary easily calculate kar payein. thank you - Sheet link for practice - goo.gl/xQQPZ6
I am very thankful to you and appreciates, please guide me for keeping accounting and other records, that is very supportive that you provide excel format too.
Great trick told sir. साल के End में 10 लाख allowance बांटना है कम्पनी मे दिनों के आधार पर लास्ट में कर्मचारी नाम, पे-स्केल, कुल हाजिरी तथा अन्त मे इन्सेन्टिव राशि show only. साथ मे फाईनल शीट मे एक लेवल के कर्मचारी अलग अलग show हो जैसे बेसिक पे. Attandence Days. भत्ता(6%of बेसिक पे) 10 GM 5 DGM 50 Sr Engineer 100 Engineer 40 Junior Enginerr 70 Technician 5
Sr pls provide all excell videos in sequence starting from 0 level .... In playlist i m confused that which video i have to watch first. Because i have just started to learn excell..
The way u explained is really very nice. As per my understanding the total work days should be presence + Off but here you calculated half days too. Kindly check and advise or correct me if I misunderstood
Sir aapne bina conditional format use krke sunday colum highlight kiya .lekin har month sunday alag date ko aayega to vo automatic nhi hoga so please sir condiational format ka use krke ek video upload kijiye
AAP ka videos M per delays dekhata hu sir bahut accha lagta hai aur hame Roz nay nay technical wali videos multi hai sir AAP aishe hi vdo bnate rhao aur hum sab log AAP ke sath hai
Sir mujhe per day attendance ke shaat ot bhi calculation krna pdta h Aise me kya formula aur kaise use kre Plz help me soon as well as possible. Thank you lot.......
Tum khud kar nahi sakte ho.dimak lagao.help option mai sob dia hua hai.pc ka matla bi hota hai.tool k use ko sikho bas dimak lagao or aage baro.kya karte ho year
Mai vdo ki tle dekh k cmnt dekhta hoo.bas ghum jata hai dimak.r a year so cho.15.sal pehe har hat mai ph ya pc na the.tab lok kyse excel word sikh k aaj high high cmpny pe job karte hai.r a yea log budfhu banate hai.mera ek chanel tha.band kar dia.yea sob dekh ke.mai grphc dsng hoo.yea sob sikha tha pehele.in logo se v achhi tarha.mehenat karo sikho.khud ki dima k se kuchh nahi hai
आदरणीय सर, आपसे मैने पूछा था कि , यदि कर्मचारी की ड्यूटी १०:०० से १८:००शाम तक है । और बायोमेट्रिक अटेंडेंस लगता है । तो किस प्रकार हम अटेंडेंस को करकुलेट करेंगे । क्या फार्मूला लगायेंगे ।बाकी सभी बातें समझ आई और प्रयोग भी किया ।हाफडे , उपस्थित, अनुपस्थिति, साप्ताहिक छुट्टी या हांलीडे। किस प्रकार निकालेंगे। अहम समस्या जैसे , टाइमिंग का है ।१०:००से १८:०० शाम तक। यदि कोई १०:३०,१०४५ या १०:५०को आया तो । सर जी कृपया इस विषय पर मदद करें।
Wrong calculation of days. Total number of presence, absence, half day, off has to be equal to total number of days in a month which is 31. But in maximum cases it is not equal to 31.
Bhai mere tumhaari baat sahi hai par pf to necessary hota hai aur muzhe pata nahi kis company mein hra milta hai par mein to jaha tak dekha hai lagbhag sabhi companiyon mein pf kat ta hai aur sarkar bhi pf mein yogdan deti hai but sawal yaha ye hai ki jab aapko hra aur pf dono method pata tha to apne logo pura method kyon nahi bataya inlogo ko to pf ka formula nahi pata unko to adhura gyan de rahe ho aap
Main is video me bata chuka hu agar hum formule me 0.5 nahi lagate to 4 half days hote. maine formule me 0.5 isliye lagaya taki jo half days hai wo full day me convert ho jayein aur hum per day salary calculate kar payein. 4 half day matlab 2 full day second example 50 paise+50 paise+50 paise+50 paise = 2 Rupees, am i right sir,. Agar phir bhi apko meri baat nahi samajh aayi to mujhe is baat ka dukh hai. ek baar main phir se clear kar deta hu aisa maine isliye kiya taki hum per day salary easily calculate kar payein. thank you - Sheet link for practice - goo.gl/xQQPZ6
, Nik Bakers 1 to 50 1 to 15 ok
Search inter
over time k liye provision kya ho sakta hai??
145360.00 how much in word????
Or 5 half ho to
U didn't use absence cell ... Why ????
बहुत बढ़िया भाई इतना अच्छा से आज तक किसी ने नहीं बताया होगा भाई । सुपर
Sir apne bahut आसानी से समझ गया थैंक्यू
I am very thankful to you and appreciates, please guide me for keeping accounting and other records, that is very supportive that you provide excel format too.
You can do it with excel
Nice information sir ji 🎉
You are just awesome, the way you taught is excellent. We are very thankful that you did this amazing video. Best teaching 👌😊💐👍🏿
Thanks 😊
Thanks bro 😊😊😊
Great trick told sir.
साल के End में 10 लाख allowance बांटना है कम्पनी मे दिनों के आधार पर
लास्ट में कर्मचारी नाम, पे-स्केल, कुल हाजिरी तथा अन्त मे इन्सेन्टिव राशि show only.
साथ मे फाईनल शीट मे एक लेवल के कर्मचारी अलग अलग show हो
जैसे बेसिक पे. Attandence Days. भत्ता(6%of बेसिक पे)
10 GM
5 DGM
50 Sr Engineer
100 Engineer
40 Junior Enginerr
70 Technician
5
Ap sort kar le us column ko jisme apne designations dali ha
@@baljeetkumar3586 you and that
चरण स्पर्श श्री गुरू जी
Dear sir
How can menassion of over time labour
Exm.4 hrs per day over time
Thanx u so much sir jii
Thanku you so much!! Very informative....easy to understand
Keep it up....good job
Thanks bro 😀😀😀
Sir pls add pf deduction cell
Thnxxx sirrr
Sr pls provide all excell videos in sequence starting from 0 level ....
In playlist i m confused that which video i have to watch first.
Because i have just started to learn excell..
Pleae also show Epf &Eps calculation
Thank you So much sir..
Bahut jankari mili aapki Iss Video se..
Thanks for learning me Bro..
ruclips.net/channel/UC6qz5RjzNKRRzrpVAF46bFg?view_as=subscriber please subs back
Aap ki is video ne meri life badal di
Thank you sir ji
Most welcome bro
Excel Sheet attached kar diya hai taki aap log practice kar sake - goo.gl/xQQPZ6
My Live Support Thanks
Jhakas bro
Excal
Microsoft Excel
The way u explained is really very nice. As per my understanding the total work days should be presence + Off but here you calculated half days too. Kindly check and advise
or correct me if I misunderstood
Sir aapne bina conditional format use krke sunday colum highlight kiya .lekin har month sunday alag date ko aayega to vo automatic nhi hoga so please sir condiational format ka use krke ek video upload kijiye
U are right bro but ye to sirf samjhaane ko banaya hai shayad usne ye wala video.
@@AbhiSharma-wp1xx ijnn nnnnnnnnnnnnnnnnmñmmm.,.mm.mnnnnñnnnnnnnm...mm..mmm.
..
.
M.m
.mm
Mmm.mmmmmmm.o
.mm..m nnn.m.mmmmmmm.mmm,mmm ..,.mmm.m.mmmm.mm..m...m.m.m..mmm.mmmmmm.mmmm..m.mm..m..mmm..mm.m.mmmm.mm.m.mmmmmm.m.mmmmmmm.mmmmmmmm.mmmm.m.mmmmm.mmm.mm.mm..m.mmmmmmm.,mmmnmmnn.m
...........?
..
.
.m..m.mmm................
..............................
.......
बहुत ही अच्छी तरीक़े से समझाया गया है।।
देखकर अच्छा लगा।।।
Thanks 😊
Great Effort from Pakistan
Sir Thank you so much very helpful 👍🏻👍🏻
Hello Sir , i liked your video, but in video your forget to deduct of employee EPF contribution of 12 %
Isme ap loans and advances ka option bhi add kar sakt ek he advance salary ke liye. Or round function bhi use kar sakte he. Salary calculation ke liye
Sir data entry ka complete course kra do plz sir excel me
Over time ko kaise maintain kre
very Useful Video, Thanks from Kathmandu, Nepal
Kindly mention EPF deduction in salary sheet
AAP ka videos M per delays dekhata hu sir bahut accha lagta hai aur hame Roz nay nay technical wali videos multi hai sir AAP aishe hi vdo bnate rhao aur hum sab log AAP ke sath hai
Thanks alam bhai
Sir agr jin ko salary pay kr di ho onko alag kesy karna ha
Es par video banao
Thanks you sir bhot hi ahccha video banaya hai aap ne 🤟
Very good explanation . why not calculate pf and employer contribution in esi also.Please show this also
Pure RUclips pe itna details me kahi vedio nahi bani apka vedio sabse achchaa h
Thank you so much Sahni ji
Sir mujhe per day attendance ke shaat ot bhi calculation krna pdta h
Aise me kya formula aur kaise use kre
Plz help me soon as well as possible.
Thank you lot.......
Sir ap ka whtsp nmbr mil jayegA
@@shayamsunder318 .9906438736
bahut hi acha explain kartey ho ap
OK bhai thanks
THANKU SIR AAP SE BHUT KUCH ACCHA SEEKHNE KO MILA HAIN.....
SIR G FORMULA THODA ARAM SE BATAYENGE TO ACHHI TARAH SE HAM LOG KO SAMAJH ME AJAYEGA THANK YOU.
R a year kisi ko v sir bol deti ho.
Tum khud kar nahi sakte ho.dimak lagao.help option mai sob dia hua hai.pc ka matla bi hota hai.tool k use ko sikho bas dimak lagao or aage baro.kya karte ho year
Kya kar rahe ho.dusre ko pysa deti ho.khud kamao dimak laga k
Mai vdo ki tle dekh k cmnt dekhta hoo.bas ghum jata hai dimak.r a year so cho.15.sal pehe har hat mai ph ya pc na the.tab lok kyse excel word sikh k aaj high high cmpny pe job karte hai.r a yea log budfhu banate hai.mera ek chanel tha.band kar dia.yea sob dekh ke.mai grphc dsng hoo.yea sob sikha tha pehele.in logo se v achhi tarha.mehenat karo sikho.khud ki dima k se kuchh nahi hai
Math ki book pe sir ak math dokh k boltha tha baki kar k aana.kyse kate the usko.
Very help full thanks for info bro from Pakistan 🇵🇰
आदरणीय सर,
आपसे मैने पूछा था कि , यदि कर्मचारी की ड्यूटी १०:०० से १८:००शाम तक है ।
और बायोमेट्रिक अटेंडेंस लगता है ।
तो किस प्रकार हम अटेंडेंस को करकुलेट करेंगे । क्या फार्मूला लगायेंगे ।बाकी सभी बातें समझ आई और प्रयोग भी किया ।हाफडे , उपस्थित, अनुपस्थिति, साप्ताहिक छुट्टी या हांलीडे।
किस प्रकार निकालेंगे।
अहम समस्या जैसे , टाइमिंग का है ।१०:००से १८:०० शाम तक। यदि कोई १०:३०,१०४५ या १०:५०को आया तो ।
सर जी कृपया इस विषय पर मदद करें।
Sir aap ye video dekh lo ruclips.net/video/kc3VTcCDmdg/видео.html
Aur main apse bahut chhota hu isliye आदरणीय शब्द का प्रयोग न करें
bhai age se koi chhota bada nahi hoto aapne kaam se hota h
Bahut Acha samjhaya sir aapne thanks for this.
Hr excel se releted video banao sir
Sir, pf ka bataya nhi
You explanation is very clear.Its help me a lot , thnx.
Wrong calculation of days. Total number of presence, absence, half day, off has to be equal to total number of days in a month which is 31. But in maximum cases it is not equal to 31.
Mere priya sir aap ne bhut hi accha formula btaya hai
Sir agar hour ke hisab se salary nikal ni ho to kaise krenge
Very soon i will make video on this topic
I m waiting
Devide the answer by working hours eg 6 or 8hours
Convert it into 100's to do calculations
Basic salary /total days of month /total hours
Bahut sahi samjhaya Bhai.🙂🙂🙂🙂
very nice information
Thank you sir for your valuable comment.
Pf option skipped but under stood it will same deduct from gross as per norms of pf deduction 12.5℅
Bhot achha btaye sir ... thank you so much
Excel me formula kaise banate hai
Thank you brother aapane bahut acche se samjhaya padhte time yah point mujhse chhut gaya tha
wt abt pf
@@agrawalboy6288 total salary*%\100
GZB. HAI BHAI BAHUT ACCHA BATAYA HAI 👏👏❤️❤️
Bhai mere tumhaari baat sahi hai par pf to necessary hota hai aur muzhe pata nahi kis company mein hra milta hai par mein to jaha tak dekha hai lagbhag sabhi companiyon mein pf kat ta hai aur sarkar bhi pf mein yogdan deti hai but sawal yaha ye hai ki jab aapko hra aur pf dono method pata tha to apne logo pura method kyon nahi bataya inlogo ko to pf ka formula nahi pata unko to adhura gyan de rahe ho aap
2
Sahi bole bhai aap
Pf mention nahi kiya ha??
Thankiuuuuuuuu very much sir bhott ache se samj aa gyaaa
formulla ko banana parata hai yadav bana banaya aata hai sir
Excel me already formula rahta hai
THANK YOU SIR BOHT BOHT SHUKRIA.HUME SEKHANE K LIYE..ALLAH AAP KO KHUS RAKHE
Thanks
GST project
Thank you sir very very helf full video thank you so much 💐💐💐🙏
Very useful vedio bhayya
Thank you sir i am new for excel your video is good
Dost sahi hai I love myself and livecurrently
Thank you dost
Nice video 👌👌👌👌
Very good video sr Thanku
Excellent sir your teaching
Lovely video### very powerful video
Very nice. Video 📹 clearty is very good
very nice, super, jhakaas, bindaas video
Thanks thanks thanks🤗🤗🤗
Very clear explanation thank u so much ur videos and clear ur formula videos. but I don't nw Hindi sir
Sir I really thank full ur video then one request English la translate panuna inum Nalla irukum elarum understand panipanga
Thanks bhai aapki video achhi lgi Attenden sheet Banana A gya mujhe
Thanks sir very nice.
Sir HR kon kon se ragister me kaam krte h .pls vedio banay
MashaAllah superb bhai
Thanks sir👌👌👌
Bohot Bohot badhiya bhai thanks so much
Bauth acha video tha thanks
Tq,
Its made me very useful and makes me understand easily..
Thanks alot
Thank you sir jee super
Thanku.....so much for making this video
Thanks sir bahut achha lga msg video
Very nice video Bhai Jaan
Ase hi video banaye or shikhaye
Thank you so much sir
Very Very Nice Video Sirji Thank you so much for your teaching
Excellent video
Thank you so much Sir, nice video
thanks bhaee btane ke liye
Thank you so much sir🙏🏻🙏🏻🙏🏻
Superb Bro...nice vedio love U
Your video hassam sir.... Very very useful to us.
Thank you Srini
Very very useful video
Sir aapka video hame bahut achcha laga aage ms excel ke bare me bataiye
Thank you so much. Excellent tutorial video.
Thank you sir for help!!
Sir aap bahut achha padate hai
Superb knowledge sir
Video ke liye thanks bhai
Welcome bhai
Thank you bro
You are to Good in explaining
Bahut acha samjaya aapne thx
I like your idea sir it helps me a lot. thanks very much sir ji.
Welcome 😀😀😀
Superb sir maind blowing 🥰
Bahut accha laga aapaka ye video