overtime Calculation formula in excel

overtime calculation on basic or gross. overtime calculation formula in excel
_/LINKS\
► Facebook:➜ / shahabislam123
► Twitter:➜ / shahabislam123
► Instagram:➜ / shahabislam6
► Website:➜ advanceexcelon...
================================================
How To Make Salary Sheet in MS Excel # 43
• How To Make Salary She...
Microsoft Word - Create Form (Office 2019)
• Microsoft Word - Creat...
How to Calculate gross Profit From Income Statement
• how to calculate gross...
Inventory Management excel formulas
• inventory management e...
How To Make Sale Report in Excel # 26
• HOW TO MAKE SALES REPO...
how to maintain store inventory in excel
• how to maintain store ...
#159 How To Make Food Cost Profit Sheet in Excel Hindi
• #159 How To Make Food ...
advance Excel Training For Job | Data Entry | functions for data analysis
• advance Excel Training...
hide excel sheet with password
• hide excel sheet with ...
#107 How To Make a Stock Management in MS Excel
• #107 How To Make a Sto...
How To Make Experience Certificate and Latter on MS word Hindi
• How To Make Experience...
How To Make Automatic student fee Collection and status system in Excel
• How To Make Automatic ...
How To Make General Ledger Trial Balance Sheet in Excel
• How To Make General Le...
#219 How To Make Daily Production Report in Excel Hindi
• #219 How To Make Daily...
How To Make Salary Pay Slip In MS Excel # 37
• How To Make Salary Pay...
how to Maintain petrol pump accounts in excel Hindi
• how to maintain petrol...
How To Make ID Card Design In Ms Word Urdu Tutorial
• How To Make ID Card De...
#283 How To Make Stock Sale/purchase or Profit and Loss Sheet in Excel Hindi
• #283 How To Make Stock...
How To Make Resume / CV with Microsoft Word
• How To Make Resume / C...
How To Make Daily Production Report For Garment industry on Excel Hindi
• How To Make Daily Prod...
how to Create Notifications or Reminders Automatically in Excel
• how to Create Notifica...
#132 How To Make Monthly Interest amount Calculate Sheet in Excel Hindi
• #132 How To Make Month...
Click to see all our videos||
/ @shahabislam4912
subcribe to our Channel ||
/ @shahabislam4912
How To Make Bill / cash Book On MS word Hindi
• How To Make Bill / cas...
How To Make Sale Price Sheet IN MS Excel Tutorial In Hindi # 51
• How To Make Sale Price...
#88 How To Make Debit Credit sheet in Excel Hindi
• #88 How To Make Debit ...
#91 How To Make Balance Sheet in Excel Hindi
• #91 How To Make Balanc...
how to calculate retirement date in Excel
• how to calculate retir...
Top 50 Excel Shortcut in Hindi
• Top 50 Excel Shortcut ...
#269 How TO Maintain Cash Book ans Petty Cash Record in Excel 2019 Hindi
• #269 How TO Maintain C...
MS Excel Complete Course Hindi ||
• #231 How To Make Reven...
File Download Link Click Link goto Website
advanceexcelon...

[@srinivas5016]

IF EMPLOYEE CAME 08:00 AM AND OUT TIME WAS NEXT DAY 09:00 AM ......HOW TO CALCULATE THE TIME

[@sangamsahni3793]

Good question...?

[@gra8mu]

After enter =D6-(MIN(8,D6)) In over time tab 0.00 reflect.

[@roomanattari1796]

Same problem here

[@EditsbyZ.]

same here

[@purvithakkar2596]

THANKS SIR ! I HAVE A QUERY THAT IF ANY PERSON COME IN 9:10 AM AND OUT AT 5:30 (WITH RECESS) THAN HE CAN'T GAIN 8 HRS. THEN HOW TO CALCULATE (-10:00) MINUTES

[@howfinrufus3100]

I have a same question as well

[@abelayan803]

Hi bro In factory they are calculate by salary 👇 Salary 12000 div 30 div 9*1.25 = 55.56/- So how to calculate this in excel...

[@Hadees92]

Me masjid ke panch wakt ki takwim creat ki he magar time Different ki wjah se problem aarahi he puri takvim me plus 2 minutes kese add karu

[@pabitrichaudhary8106]

hi sir hame ek hi employee 3-4 bar outgoing kare ga tyo uas time ➕ karna hai us k bad 70 mms - kar k baki minus nikalna hai

[@gra8mu]

=D6-(MIN(8,D6)) This formula not running after create same sheet as you create. Please help

[@mizanurrahman-ho7zh]

this formula can't working in excel sheet

[@AsrafAli-pr5ls]

Dear Brother, I can't understand How Farhan gets 400. When he works 6:00 hours. plz clear me.

[@ashramzakaf6962]

I was thinking about the same thing, but he could change the equation to, ( total hours + 1/2 *over time) * pay per hour . I hope that help

[@Armas-or3ej]

Last Colum Main 6 Hours Duty Hai Woh 2 Hours Minus nahi huva But Why.

[@learningcenterHD]

Great work carry on sir a lot of thanks

[@maheshkhilolani4100]

sir jo log sham to jaldi chale jatie hai means 2 hours jaldi jate hai to uska paisa kat karna company bole uski formula batavo

[@shahabislam4912]

g thek he. Topic p upload hojegi video

[@sunnykumarize]

Very nice video

[@maheshgarg2647]

Sir ye ek din ke over time nikalne ke liye ok format hai but ek mahine ka pura banane ke liye formula bataye plz sir .... Ta Thank you sir for this vdo

[@shahabislam4912]

kzbin.info/www/bejne/laDMY6ltaLl8jKc

[@vijaykumar-nt3hd]

💞Thank you so much ✔️🇮🇳

[@muhammadshakeel4482]

Very useful sheet

[@prashantbarua3228]

Pure month kaa calculate krke btaoo,,1din ka to nikal jaa rha hai..

[@Allahuakhbar803]

9:00 AM To 9:15 AM No deduction count on salary after 9:15 count 16 Mints & and overtime start after 6:15 PM 35% include in hourly salary attendence allowance and also deduction of loan & advance many confusion in short time or late time manage with 1 sheet

[@maheshkhilolani4100]

aur sir jo subha late ata hai aur sam to jaldi jata hai to kase formula banega

[@mdanwar5092]

Sir video Thora jayada ho per barike se btaye

[@azharuddin2815]

Sir isme time date aur basis pay se calculate karna hai please sheet bhje

[@muhammadshakeel3471]

Assalamualaikum excellent

[@hamzatahseen7315]

Month Wise ka calculate kaise hoga . Aur lunch ka time nahin liya hua . Meri factory me 1 hour lunch time hai. Iska koi easy formula hai.

[@A_1636]

Agr 8 hour se kam ka calculation krna ho to ?? Jaise kisi ne 1 bje tk work kiya ye 8 hour se kam hai to eski calculation kaise hogi ??

[@Hadees92]

Namaz ki Takveem me 365*7 sell me 2 minutes plus keae kare

[@alyaharentertainmentcenter448]

Sir G apny lunch time in or out ka colmns nhi add kya unki b calculations b kro aik video me plz

[@mohanpal13555]

Great vedio

[@VK00789]

Agar in time 21:30 pm ho or out time 07:30 am ho to konsa formula lagega

[@shahabislam4912]

kzbin.info/www/bejne/mafOaWp3gdRrqJI kzbin.info/www/bejne/jX_Ygqt8ZbCVfdE kzbin.info/www/bejne/qH-UpYaBatSNjrM

[@muhammadjamil3102]

Dear sir, how can i charge ie (0:05:07) Rs .43/20 seconds, every

[@ruholamin5873]

Great job brother thanks 😊

[@production.coppergat]

CAN YOU HELP ME PLEASE, HOW TO SHOW THE FOLLOWING GIVEN BELOW; 8:15AM TO 8:30AM MENTION -1HOUR, 8:31 TO 9:00 MENTION -2HOUR, 9:01 MENTION -4HOURS, 12:00PM MENTION -4HOURS, 3:00PM MENTION -2HOURS, 4:00 PM MENTION -1HOURS ALL THIS IN ONE CELL IS THERE A WAY?

[@SourceofLearning]

Excellent work sir... very usefull....

[@rajatpatra7174]

Sir, I want min calculate on OT(hr:mm) . How do sir please reply me.

[@A_1636]

Bhai es file ki last entry check kro 6 hour work kiya hai firr bhi 400 rupy hi dikha rha hai

[@Mu-chhod53]

Agar 8 ghanta duty h 3 ghanta OT h 2000 basic h to 3 ghanta OT karege to ketna joga

[@surjeetchanana7181]

agar koi time se pehle gaya hai to,uska overtime minus bhi to hona chahiye. to waise kaise less hoga?

[@sunnykumarize]

Sir employees 1 hours is sheet main lauch kaise less karne ka formula kya hai?

[@adityakahl]

But the last employee worked only 6hrs so he should get 6*50=300 but he got 400

[@gauravdronacharya]

Bhai salary k hisab se ... overtime kya hota h yrr .... suppose agr 8 hour ki 8000 salary hai (one month) then over time kitna mileaga salary k hisab se

[@shahabislam4912]

1.5 per hour milta he salary ka

[@lecuae]

What if the time is in hours,, minutes and seconds?

[@manavrastogi2027]

over time calculation in case of out time is after 12pm

[@shahabislam4912]

kzbin.info/www/bejne/aZyrn4OIo8Z_Z9U

[@mdanwar5092]

Sir hours nhi nikal Raha hai aap ka formula se

[@tsrtapansurekharohan608]

Time ko paisha se multiple kese Karen

[@VK00789]

Sir agar in time 21:00 or out time 08;00 hoto formula ky hoga

[@shahabislam4912]

kzbin.info/www/bejne/jX_Ygqt8ZbCVfdE

[@dipdas7002]

Sir Total Mhai Problem ho rahi hai 192 a rahi hai 1st in out k bad total mhai 192 a rahi hai

[@JyotiSingh-ve9xu]

Isme 1.5 % jo liya tha usme percent ka sign kyu nhi lgaya ya fir 100 se divide kyu nhi kiya

[@ugrasenmshr2]

Kisi qty me se 6 minuse karne par agar 6 se Kam ho to 0 aur 6 se adhik jitna ho wo kaise aiyega

[@sabithtp7422]

Hi sir, possible to download the link. I want this excel sheet please

[@deepakchaudhary0710]

Sir agr in time out time opposite ho to kaise krenge?

[@travelingplacesinnepal8467]

Pura 30 dinaka kesa karana chahiye sir g?

[@hameedkhan2272]

Sir 1100 basic hoto 2 ganty over time hogai monthly kitna bnta aed

[@memoriesold6116]

after"=(out-in)*24)" result 0.00 and drag mood also shown same.

[@RadhaKrishna_684]

Sir salary alag alag hai kaise nikale

[@SachinKumar-iy9tk]

Double shift krdi ager kisi ne toh nahi apply hota ye for ex- 9:00 AM to 2:00 AM krke dikhana

[@rajuexpert2807]

islam shab starting se batye bhai ise kayse banana hai

[@shahabislam4912]

kzbin.info/www/bejne/gHmtomiZjtR-hac

[@MahtabAlam-lh4lk]

If Per hour Rate will be different for every body the how to apply formula...?

[@secondwise786]

Yes i m looking the answer

[@dzgrowup4676]

But bro with date ana chahe hain from Pakistan

[@0000iequ]

Hii sir, Sir advance excel kiya hota hai ispe full video bnaiye sir.

[@t.k.rahimanthiruthikattil6159]

night duty, means 19:00 to7:00 how calculate?

[@theknowledgeadda1484]

19:00 pm to 03:00 am=8 hours then 03:00 am to 07:00 am=04 hrs ot

[@Manishdyat]

Sr jsay 2hour km ayaaa uskaa ksaye

[@saghirahmadsindhu3401]

Sir plz explain per hour 1.5 fix or flexible

[@kingbhawani24]

RAM RAM BHAI

[@MrPintu1000]

Ek chiz batao sir ji agar mera time 8 baje tak ka he raat ka or me 2 bje raat ko jata hu to sheet kyu nahi ban rahi

[@shahabislam4912]

kzbin.info/www/bejne/eoObm51vrb6EpKc kzbin.info/www/bejne/qH-UpYaBatSNjrM

[@Rkkushwah1]

Sir full month adendenc time by time

[@mohamedsadiqm]

Assalamuallaikum Bhai,Which format is selected

[@kajalsingh-ui6rn]

Last ka 6 ghanta aa raha hai usko bhi 400 kyon

[@musakirq6766]

A w bhai koi ashan formula hai kya

[@akshaysingh8129]

Wages par day system pay kar Raha h to Nahi ho raha

[@iqbalganatra3572]

Great Sir❤️ Informative ❤️

[@englishandmathstricks5242]

2 in 2 out ho to formula kya bnega

[@rockeyhandsome9079]

Sir full month ka overtime for qatar

[@annybhatt4270]

Out in to one day ka h month na kaise karnge

[@amritsunara3651]

Mathematics padhao vai

[@chiragpatel-vg2cz]

Example _1 hours na 40 rupees To 1.5 person kitna hota he over time na

[@shahabislam4912]

60 rupees

[@Hadees92]

In excel 2016

[@raghunirvanaswamy4675]

What is this 1.5 in the last column

[@sherghimire5233]

you did not consider weekends or holidays in this video

[@minalwadekar5223]

This formula is not working

[@Neerajyadav-hh8kx]

Every Day Ka calculation kaise karenge

[@AkybabuAky]

1.5

[@saddamali1494]

Cell add karne se time 0:00 ho jata hain

[@travelingplacesinnepal8467]

Pura 1 mahinaka k se karna h g

[@samitavishwasrao5205]

pura day wise kaise karna hai?

[@Rima18018]

OT Wages is to be given at double rate not 1.5

[@shahabislam4912]

yes

[@Skthebright]

Sir kisi ka salary 15000 our kisi ka20000 ho to

[@RamYadav-yv9ss]

Super sir

[@janathanngrabha1477]

I didnt understood of wages cell

[@santoshkumar11200]

GWR ka matlb kya hota hai

[@nitishgujral6093]

Not working

[@akshaysingh8129]

Formula

[@saddamali1494]

Formula work nehi karta hain

[@hrishabhkumar4635]

Sir multiply samajh nhi aya

[@pankajkumargujjar2501]

Over time par formula kaam ni kar raha

[@awarenessongoodandbadpoints]

Sort time not calculate

[@neetishkumar5457]

Jiska 450 hai to

[@aliarzam8547]

Over time 8 se kam tha minus hona chaye tha

[@mashood4993]

NOT ACCURATE

[@jassmark1751]

ᏞᎪႮᎠᎪ ᎡᎪᎻᎷᎪΝ ᎡᎪᎻᏆᎷ

[@ahamad___0786]

Apna number send kr skte ho bhai

[@asthasinghsingh7714]

Brother 1.5 qu likh rhe ho

[@shahabislam4912]

per hour pay 100 he agar to overt Time 1.5 yani 150 milta he.

[@asthasinghsingh7714]

@@shahabislam4912 brother per hours wages 50 hai to 1.5 qu likh rhe hai can you describe me

[@vishnubhaipatel3306]

How to divide h:mm 600:30/6:15 in excel

[@Allahuakhbar803]

0.25 quarter equal to 15 min + - function