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