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