Thank u so much sir for such a excellent trick (24 multiplication with "hh:mm:ss"), this trick totally absorbs my headache while calculating guild Technicians' payment sheet.....
Sir, We have 152 employees if one sheet for one employee we will create 152 sheets in a single file. Is it possible? Is it possible to do it in a single sheet?
मेरे पास केवल In Time & Out Time है उसमे से मुझे 2 type का data अलग करना है 8:30 घन्टे का regular time & बाकी बचा हुया ओवर टाईम अगर कोई रेगुलर समय से पहले ही चला गया है तो उसका समय minus मे आना चाहिये जीतने समय पहले वो जाये & उसका ओवर टाईम Zero Show होना चाहिये इसके लिये कोई फॉर्मूला बताये
sir me jab ot rate ki neche calculation start karta ho to overtime 11pm ke bad yani 23:00 ke bad sum ka formula type ke bad bhi counting thek nai hoti pls resolve my issue
Sir mujhe apka calculation galat lag raha h...Ek employee one day 5.30 hours OT karke 1375 kaise kama sakta h....Agar wo daily aise hi 1 hour bhi OT kare toh his Overtime Income will exceed his salary.
Sir bohot help huya
Bahut acchi video lagi aapki Bhai ji
Its really very help full
wao you solved my big problem. thanks sir.. .
Really great teacher
Thx bro and it was useful for me coz I was working while I saw this video
Awesome video
Shukriya Suvef
Thank u so much sir for such a excellent trick (24 multiplication with "hh:mm:ss"), this trick totally absorbs my headache while calculating guild Technicians' payment sheet.....
Thanks a lot for uploading this video.
Form a long time I'm waiting.
Thank u so much sir
Nice Guru Ji
Thanks Vishnu
Thank you Guru ji..
Hi
Need help
How to subtraction 1:30 from 12:00am
Love from uttarakhand
Thanks Harrys
Exelent
OT निकालने का फॉर्मूला दोबारा बताये
अगल से वीडियो बनाये
Sir, sunday ke liye kya kre ..
Thanks
Welcome Bikash
Instead of No OT ,if I want minus working hours to be displayed then how to do
Sir, We have 152 employees if one sheet for one employee we will create 152 sheets in a single file. Is it possible? Is it possible to do it in a single sheet?
Sir total Ot Hours me calculation nahi ho pa raha he MS Offce 2007 me Please Help
How to calculate that how many person exits form office last 2 hrs or 3 hrs if Date and time in same colum.
I love you
Yeh wala file download Nehi ho pa Raha hai. Kisi aur tarike se download karne ke liye bandobast kijiye.
Sir thoda zoom karna chahiye aapko.
मेरे पास केवल In Time & Out Time है
उसमे से मुझे 2 type का data अलग करना है
8:30 घन्टे का regular time & बाकी बचा हुया ओवर टाईम
अगर कोई रेगुलर समय से पहले ही चला गया है तो उसका समय minus मे आना चाहिये जीतने समय पहले वो जाये & उसका ओवर टाईम Zero Show होना चाहिये
इसके लिये कोई फॉर्मूला बताये
SIR THIS FORMULA IS FOR PM- AM.... BUT I NEED AM-PM FORMULA CAN U HELP ME IN THIS???
Sir ye apka formula show nahi ho raha ap coment mai likh kar de denghe kya
how to scrap the data from any website without coding
sir me jab ot rate ki neche calculation start karta ho to overtime 11pm ke bad yani 23:00 ke bad sum ka formula type ke bad bhi counting thek nai hoti pls resolve my issue
how to make formula for night shift like start time 19:00 to 07:00
👍
Sir agar kisi employee ki duty 9:30 per close Hoti hai aur wo 2 am tak kaam karta hai tab uski ot kaise calculate hogi ?
You are genuinely
sir ak bar ap it Ka formula bhi kr kai dhikhata to shi tha
OT निकालने का फॉर्मूला गलत है
Minus करने से डाटा गलत हो जाता है
For Ex
22:35-06:15
इसे करके देखो
Sir overtime sub kar raha na.
Sir, Ajkal kio jada video upload nahi hota
Sir yadi ek ghante ka 100 rs h to isko kaise entry kare in time aur out time me
Sir, site se excel file download kese hogi. Mene meri mail id or no. Bhi dale hai. Fir bhi nhi ho rhi
Koi or site open ho rhi h.🤔🤔🤔😌😪
Site se hogi Mene bhi ki hai wahi se
Sir mujhe apka calculation galat lag raha h...Ek employee one day 5.30 hours OT karke 1375 kaise kama sakta h....Agar wo daily aise hi 1 hour bhi OT kare toh his Overtime Income will exceed his salary.
O.t ka rate kayese nikale per ghante
24 hrs not working
Bhai formula to bolo..
No number hah
Please speak english as usual
I will make the English version in 2 days and post