overtime Calculation formula in excel
ฝัง
- เผยแพร่เมื่อ 12 ก.ค. 2020
- overtime calculation on basic or gross. overtime calculation formula in excel
_/LINKS\
► Facebook:➜ / shahabislam123
► Twitter:➜ / shahabislam123
► Instagram:➜ / shahabislam6
► Website:➜ advanceexcelonline.blogspot.com/
================================================
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
advanceexcelonline.blogspot.c...
Excellent work sir... very usefull....
Great vedio
Great work carry on sir a lot of thanks
Great job brother thanks 😊
Assalamualaikum excellent
Very nice video
Very useful sheet
IF EMPLOYEE CAME 08:00 AM AND OUT TIME WAS NEXT DAY 09:00 AM ......HOW TO CALCULATE THE TIME
Good question...?
💞Thank you so much ✔️🇮🇳
After enter =D6-(MIN(8,D6)) In over time tab 0.00 reflect.
Same problem here
same here
Sir G apny lunch time in or out ka colmns nhi add kya unki b calculations b kro aik video me plz
RAM RAM BHAI
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
I have a same question as well
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
th-cam.com/video/_oi2v73TIVE/w-d-xo.html
Pure month kaa calculate krke btaoo,,1din ka to nikal jaa rha hai..
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...
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
Sir isme time date aur basis pay se calculate karna hai please sheet bhje
Last Colum Main 6 Hours Duty Hai Woh 2 Hours Minus nahi huva But Why.
1.5
Sir video Thora jayada ho per barike se btaye
Great Sir❤️ Informative ❤️
Hii sir,
Sir advance excel kiya hota hai ispe full video bnaiye sir.
What if the time is in hours,, minutes and seconds?
Sir plz explain per hour 1.5 fix or flexible
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
In excel 2016
Sir full month adendenc time by time
after"=(out-in)*24)" result 0.00 and drag mood also shown same.
Sir employees 1 hours is sheet main lauch kaise less karne ka formula kya hai?
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
g thek he. Topic p upload hojegi video
agar koi time se pehle gaya hai to,uska overtime minus bhi to hona chahiye. to waise kaise less hoga?
Assalamuallaikum Bhai,Which format is selected
Pura 30 dinaka kesa karana chahiye sir g?
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 ??
Kisi qty me se 6 minuse karne par agar 6 se Kam ho to 0 aur 6 se adhik jitna ho wo kaise aiyega
Launch time kaise less kare is excel sheet main
Dear sir, how can i charge ie (0:05:07) Rs .43/20 seconds, every
But bro with date ana chahe hain from Pakistan
Every Day Ka calculation kaise karenge
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
Sir full month ka overtime for qatar
Sir, I want min calculate on OT(hr:mm) . How do sir please reply me.
Dear Brother, I can't understand How Farhan gets 400. When he works 6:00 hours. plz clear me.
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
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?
islam shab starting se batye bhai ise kayse banana hai
th-cam.com/video/JHJq5cYoKOE/w-d-xo.html
over time calculation in case of out time is after 12pm
th-cam.com/video/3kHnPRnaL1s/w-d-xo.html
Agar 8 ghanta duty h 3 ghanta OT h 2000 basic h to 3 ghanta OT karege to ketna joga
Time ko paisha se multiple kese Karen
Sir Total Mhai Problem ho rahi hai 192 a rahi hai 1st in out k bad total mhai 192 a rahi hai
=D6-(MIN(8,D6)) This formula not running after create same sheet as you create. Please help
this formula can't working in excel sheet
Sir agr in time out time opposite ho to kaise krenge?
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.
OT Wages is to be given at double rate not 1.5
yes
aur sir jo subha late ata hai aur sam to jaldi jata hai to kase formula banega
What is this 1.5 in the last column
Sir 1100 basic hoto 2 ganty over time hogai monthly kitna bnta aed
Double shift krdi ager kisi ne toh nahi apply hota ye for ex- 9:00 AM to 2:00 AM krke dikhana
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
1.5 per hour milta he salary ka
Agar in time 21:30 pm ho or out time 07:30 am ho to konsa formula lagega
th-cam.com/video/cvk87ALo8r0/w-d-xo.html
th-cam.com/video/WNuQxF0KbGo/w-d-xo.html
th-cam.com/video/rN1tSK5oZXQ/w-d-xo.html
If Per hour Rate will be different for every body the how to apply formula...?
Yes i m looking the answer
Hi sir,
possible to download the link.
I want this excel sheet please
Bhai es file ki last entry check kro 6 hour work kiya hai firr bhi 400 rupy hi dikha rha hai
Out in to one day ka h month na kaise karnge
Mathematics padhao vai
Namaz ki Takveem me 365*7 sell me 2 minutes plus keae kare
2 in 2 out ho to formula kya bnega
Wages par day system pay kar Raha h to Nahi ho raha
A w bhai koi ashan formula hai kya
pura day wise kaise karna hai?
Super sir
Sir salary alag alag hai kaise nikale
Sr jsay 2hour km ayaaa uskaa ksaye
Cell add karne se time 0:00 ho jata hain
But the last employee worked only 6hrs so he should get 6*50=300 but he got 400
Over time 8 se kam tha minus hona chaye tha
GWR ka matlb kya hota hai
Sir kisi ka salary 15000 our kisi ka20000 ho to
I didnt understood of wages cell
Sir agar in time 21:00 or out time 08;00 hoto formula ky hoga
th-cam.com/video/WNuQxF0KbGo/w-d-xo.html
Isme 1.5 % jo liya tha usme percent ka sign kyu nhi lgaya ya fir 100 se divide kyu nhi kiya
Pura 1 mahinaka k se karna h g
Sir hours nhi nikal Raha hai aap ka formula se
night duty, means 19:00 to7:00 how calculate?
19:00 pm to 03:00 am=8 hours
then 03:00 am to 07:00 am=04 hrs ot
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
th-cam.com/video/DR8jj9xYQnE/w-d-xo.html
th-cam.com/video/rN1tSK5oZXQ/w-d-xo.html
Formula
you did not consider weekends or holidays in this video
Example _1 hours na 40 rupees
To 1.5 person kitna hota he over time na
60 rupees
Over time par formula kaam ni kar raha
Sir multiply samajh nhi aya
ᏞᎪႮᎠᎪ ᎡᎪᎻᎷᎪΝ ᎡᎪᎻᏆᎷ
Last ka 6 ghanta aa raha hai usko bhi 400 kyon
This formula is not working
Jiska 450 hai to
Sort time not calculate
How to divide h:mm 600:30/6:15 in excel
600:30 / 6.25
0.25 quarter equal to 15 min + - function
Not working
Formula work nehi karta hain
Apna number send kr skte ho bhai
NOT ACCURATE