How to Maintain Overtime and Overtime Wages or Salary in Excel for One Month | Tutorial in Hindi

[@MyLiveSupport]

Must watch this video - How to Maintain Attendance Register and Salary Sheet in Excel | Step by Step Tutorial in Hindi kzbin.info/www/bejne/pmGme5alodmsbrc

[@Mdminin420]

Hey Dude how can i get sum of total overtime salary and basic salary???

[@kamrankhan-qx6ks]

A o a sir lot of bundle of thanks I was to much worried. Your sheet is very easiest. & Helpful. Thanks

[@learnget8053]

I see about 20 videos but ur video is the top 1of them

[@MyLiveSupport]

Thank you 🤗💐

[@rajivkumarshah1980]

you did not mention how to manage half day of a week & weekly holiday, also missing any holiday ( i.e. festivals). waiting for your satisfying reply.

[@saritapatel2849]

Thanku kafi achhe se banaya dikhaya

[@pari-techfinance]

मेरे पास केवल In Time & Out Time है उसमे से मुझे 2 type का data अलग करना है 8:30 घन्टे का regular time & बाकी बचा हुया ओवर टाईम अगर कोई रेगुलर समय से पहले ही चला गया है तो उसका समय minus मे आना चाहिये जीतने समय पहले वो जाये & उसका ओवर टाईम Zero Show होना चाहिये इसके लिये कोई फॉर्मूला बताये

[@ghurahuprasadyadav3798]

Respected sir. I'm G P YADAV. This is very valuable for us. Thank you heartily for all these formulas.

[@MyLiveSupport]

Thanks brother

[@tulsirambaraskar2444]

Dear sir I want to prepare salary sheet with commission, over time, advance . Please show me this type of video. My contact no. 9340584839

[@AvinashSingh-im4oc]

@@MyLiveSupport how to include weekly off and holyday in this sheet

[@neerajchandra3546]

Overall very knowledgeable and useful sheet.

[@ProudPakistani74]

bohut umda

[@pratimadeshmukh5111]

Very nicely explained 👍🏾

[@Yogsaini010]

Bht hi badhiya

[@sakshishivani2915]

Thank you so much 😊

[@imtiyazali705]

THANK YOU FOR SHARING SUCH A PROFOUND KNOWLEDGE PERTAINING TO SALARY OR OVERTIME SHEET BUT I M CURIOUS TO KNOW HOW TO FIND SPECIFIC EMPLOYEE DATA QUICKLY.. FOR INSTANCE EMPLOYEE CAME AT WHAT TIME ON THURSDAY OR FRIDAY OR ANYDAY.. ANY DAY OR DATE.

[@bodhisattwabanerjee7637]

aap ek master payroll dekar esi pf ptax tds bonus loan gratuity over time etc. dekar video layie plz aur jo excel sheet dikhayenge uspe woh description main plz plz share kar dijiye isse hum jaise students ka accha hoga ghar main practice kar sakenge

[@sauravkumarbharti2762]

Basic salary +overtime time salary. Ko add krte hai to bhut jyada aa jata h sir ... Total in hand salary

[@gauravbhatia7987]

Thnq sir so much

[@asgharawan1998]

Good brother

[@sonukumar9269]

Thanks bro

[@prabhatdas8369]

Bhai nhi ho raha ha total month time 12:00 araha ha

[@jyotiahuja60]

Exacty mere se bhi nhi ho paa raha total working time 12:00 AM aa raha hai

[@9922489092]

Mere excel sheet me four late coming me half day lagta hai 4 "L" means half salary cut aur 5/6/7 late coming me bhi half day ka hi amount dikhna chahiye but agar 8 late mark hote hai to 1 day salary ka amount ana chahiye multiple of 4 late mark half day ka salary cutna chahiye

[@datascientists0]

Great effort brother..

[@NafeesKhan-tk6oy]

Bahut achchha sir

[@MyLiveSupport]

Thank you big b

[@RAJUKUMAR-nt8vk]

Sir Mustor roll maintain Krna compulsory h??

[@BilalRaza-di8jy]

Janaab.. Late coming minutes calculate krne k lie Kya tareeqa istemal Kia jaega..?

[@ramijbiswas740]

Thanks bro thanks I love you

[@KARANSHARMA-bm9et]

Sir working time pr formula use krty hai to value likha a jata hai naki working time.pls

[@sukritigoel8049]

Agar mjhe if condition use karna ho toh formula kya hoga

[@Mdminin420]

Hey dude how can i get sum of total overtime salary and basic salary

[@ashuthakur9815]

Sir night shift me working time calculate nahi ho pa rha h pure month ka

[@pashumitravaibhav38]

Sir jyada tr excel ka konsa version chalta hai

[@udayuday7854]

sir 1 sheet par attendence lagata rahe aur dusari sheet par jisapar shalry bana rahe hai uspar add hota chala jaye. koi is tarah ka video banaiye.

[@moodkn]

Helpfully

[@MyLiveSupport]

Thanks

[@learnget8053]

U r great

[@rajdon9345]

Over time to nikal gaya but jab me over time basic salary ko jod kar total salary nikal raha hu to value galat aa rahi hai usko kaise thik kare please help apki video ne meri kafi help ki bas yahi aakar problem aa rahi hai

[@lionfee1595]

Nice sir

[@MyLiveSupport]

thank you ankit

[@learnget8053]

Thanks..sir

[@krishnamagar5410]

Hello sir namaskar jaise apne video banaya 8:00 Am to 4:00 pm / but 10:00 pm to 7:00 Am kaile County karega over time

[@amar.k.bservices4709]

Only one column pe daliy duty hours and ot hours site column pe kese olaga se niklega

[@aartichauhan8960]

Nice, thanks sir

[@MyLiveSupport]

thanks aarti ji

[@krushnaakash4845]

bro i ma getting one problem if any takes holiday or late then getting #### what to do

[@irfk7746]

If someone taken leave than how we calculate total 31 days hours

[@threesister9996]

Sir working time ka formula nhi lag raha because aap ne bich me change keya hai formula or mery laptop me f4 se change nhi ho raha hai

[@neerajchandra3546]

Overtime payment should be 2 times of the normal or regular hr wages as per indian factory act

[@kj007rw]

Overtime wage should be double.. If I am not wrong OT=OT HOURS*1 HOUR SALARY*2

[@pari-techfinance]

Working time निकालने का तरीका गलत है Minus करने से डाटा गलत होता है 22:23-06:17 Ye krke dekho गलत होगा

[@kirankaur2817]

nice

[@pari-techfinance]

गलत है हर जगह minus किया आपने In time- 19:28 Out time- 07:49 Regular working time- 08:30 Hours अब आप Total Hour & over Time को निकाल कर दिखाओ Minus करने से गलत आयेगा

[@deepakhanumante9852]

Sir jis din holiday hoo us din kyA karenge

[@maheshmaurya5738]

Advance -kar ke final payment ke baare main bataaen

[@rajeshgajul7547]

Bhai super

[@MyLiveSupport]

thanks rajesh ji

[@sunilnihal5096]

In 12 house dudy means how to calculate attendance place give a video sir

[@manishverma532]

Bhai agar person lunch time se pehle chala gya to kaise time calculate kro ge uske

[@Ansh12381]

Please share this excel sheet link, so we can download this sheet, thanks

[@traveltours7641]

WILL YOU GUIDE ME SIR =SUMIF(RC[1]:R[17]C[16] IN THIS TYPE O HELP ME OUT ON THIS

[@m44431]

Very helpful video but, I am not able to get total hours in month, overtime hours figures. Can you help me out

[@PP-qs2rl]

Same issue facing... Do you hv any solution

[@ninja918]

Sir pls formula btao jisme in time 9 am daal kr or out time 5:30 pm daalne k baad uske baad k hours Over time m chle jaye

[@jyotiahuja60]

Yes mujhe bhinisi tarah ka formula need hai kya aap kar paye plzz tell me

[@sandeepmaurya7582]

SIR SUNDAY KO HOLIDAY OR WORKER OVERTIME PAR AYA H OR ABSENT YA HAFE DAY KASE NEKALEGE

[@MyLiveSupport]

iske upar bhi ek video already banaya hai channel par jake dekh lo

[@brijeshgupta4237]

Sir mai ye janana chahta hu ki yadi 1 Hrs ka 100 rupya hai to to 1.30 Hrs ka kitna hoga kaise nikalege

[@SureshKumar-mg3ig]

Total Salary nikalne k liye overtime+basic salary karne pe nahi aaraha please help 😣

[@vivektripathi2439]

Sunday ko off rhta hai per half day work karte hai to kaise nikalte hai overtime

[@Engineer_Sahab2013]

How to maintain present and over time in sheet

[@Raushankumar-di1lk]

total over time 2000 ok but net salary ke liye Net salary + Total over time can you help me

[@NoobGaming-ym6zi]

Sir ek deta me telephone no & mobile no hai usme se mobile no ko alag kaise nikalenge

[@sandipghosh2098]

overtime ka sath agar app basic salary sum karenge to figure galat arahahai

[@TipuSultan-qu7zk]

sir how to i can print this sheet?

[@jpgoyal400]

What about holidays

[@sunilsk7243]

Basic salary main ager over time value plus krte hai to total sahi nahi aata

[@Pradeep2929]

Sir Daly workbook ka link send kre

[@sujeetvishwas8706]

Full months salary sheet over time witth absence

[@brijeshsinghrajput9035]

SIR WORKING TIME SAHI CALCULATE NAHI HO RAHA HAI

[@ronginfanus113]

Now a days all offices use software, not excell sheet

[@72yogendra]

Excel 2016 me kese banayenge

[@fardeenkhan9579]

Sir ye jada badhi sheet ho gyi thodi choti btao

[@Zeem8BP]

Bro lunch time 1 hour ka h to 31 days ka total 7 kyo aa raha h

[@ashuthakur9815]

Sir ye excel sheet mil sakti h

[@MyLiveSupport]

Download from Description

[@viveksood3068]

plss share this sheet

[@kushwahaanjali714]

Pf or esic ke sath video

[@Staywithneha]

How to add dedection salary

[@MyLiveSupport]

Watch my other video attandance sheet

[@milankushwah]

Or agr lunch 30 minutes ka hai or pr usse jyada kr liya man lo 45 minutes fir use kese dikhayenge

[@ramijbiswas740]

8 AM TO 9PM KA HISAB KAISE FORMULA LAGAYE

[@AbdulSattar-wg8cv]

Dear i need to contact you . I need your help

[@printandpackers99]

sir download kasa karay

[@adityarjstatus9750]

Hello sir

[@vijaypatel-xb7wn]

Car carry over report Pending car next day show

[@jaienterprises5839]

Bhai over time ka rate alag hota hai

[@sandeepjangra590]

Sir video ki quality clear nhi hai

[@dipenpatel4972]

Hiii Sir Ye Excel to Superb hai aur mere liye bohot usefull bhi hai Lekin muje isme ek query hai to kya aap is regarding aapki koi mail id de sakte hai ??? To usme mai exactly meri query ko bata saku

[@MyLiveSupport]

Thank you so much 🥰

[@dipenpatel4972]

Pls support me regarding my queries [e-mail]

[@kajalsingh-ui6rn]

Sir I am sorry to say your sheet are wrong I think Sunday half day ya employees working only 15teen day,s how to find out over time other wise employee 5 day,s only working per day 4 hour

[@msgraphics2024]

How to feel absence

[@AvinashSingh-im4oc]

We need to add one more collamn for Making them Present Or absent

[@AvinashSingh-im4oc]

Present absent collumn ad kijea her din usme Presnt ke lea P aur absent ke lea A Enter kijea. Basic salery calculate karne ke phale ek aur Collmn add kijea jisme P ka count nikalea conut if ka use karke "p" Ka jitna count aye usse per day ka salery ko multyply kijea isse uska Basic salery nikal jayega aur Fir baki video dekh lijea

[@KulwantSingh-jz6wb]

Agar Sunday ha fir

[@maheshmaurya5738]

Formula sahi kaam nahi kar raha hai time aur time*to rs galat aa raha hai

[@annybhatt4270]

Sunday ka to btaya nhi

[@faisalalam8677]

normal hr $8 ho to over time hr $12 hotahay o kasey nikley ga

[@manojm4867]

Over time and actual time or total overtime salary me ##### a raha h

[@er.prasantpuri2866]

Thans sir for excel file. Prasant mallick. Odisha. 9348180950. Sree joyguru engineering.

[@arvindanavinbhaishah6646]

Sri aapka nmbr milega? I'm Nirav shah

[@MyLiveSupport]

Search video on my channel. You will get number

[@aamirkhan9650]

Pehele khud sikh le

[@amitkumarsingh7044]

Sir, Mujhe aapki video me attendance sheet bahut pasand aayi hai Please aap mujhe meri mail par attendance sheet bhej sakte hain Thankyou Sir, Amit singh [e-mail]

[@aaban-i5v]

Thank yo so much

[@faizmohmmad7813]

Nice sir