Find Employees Overtime In Excel 💯 | Excel Hindi Tutorials 🔥
HTML-код
- Опубликовано: 11 сен 2024
- Find Employees Overtime In Excel 💯 | Excel Hindi Tutorials 🔥 #shorts #excelshortcuts #tips #excel #tricks #exceltricks #excelfunctions #data #interview #exceltips #excelshorts #exceltips #msexcel #tech #excelfunction #excelformula #techno #howto #excelformula #msexcel #exceltips #trending #student #tech #study #exceltutoring #office365 #file #excelinterview #excel #exceltutorial #excelformula #newshort #border #exceltutorials #exceltrick #tricks #learning #exams #viral #viralshorts #learnexcel #learn #techtipsandtricks #infotainment #msoffice #microsoftexcel #microsoftoffice #techshorts #technology #viralshorts #excellearning #msexceltutorials #learningvideos #learnexcelfree #msexceltraining #interviewquestions #exceltutorialforbeginners #bytetech
Please Follow Me Here :)
Instagram : _bytetech_
Facebook : www.facebook.c...
RUclips : @byte_tech
employees overtime in excel,overtime,calculate overtime in excel,excel formula for overtime over 40 hours,overtime calculation in excel,excel,overtime pay,excel formula to calculate overtime after 8 hours,overtime format in excel,calculate overtime hours in excel,how to calculate overtime in excel,overtime calculation formula in excel,employee overtime sheet,employee overtime in excel,excel overtime formula,overtime excel formula,overtime formula in excel
excel tutorial in hindi,excel tutorial,excel in hindi,microsoft excel,excel tutorial for beginners,excel tutorial for beginners in hindi,microsoft excel tutorial,ms excel tutorial,excel,ms excel,excel hindi tutorial,learn excel in hindi,excel course in hindi,complete microsoft excel tutorial,excel tutorials,excel tutorial hindi,excel in hindi full course,excel full course in hindi,excel in hindi tutorial,ms excel in hindi,excel for beginners
Itna yaad kis ko raheta h 😂
💯
Exactly bhai 😢
Best things of this video you explained fully formula
I don't know why this formula is not working in my laptop
Bhut mst padhaya
Best
Ye tumhara kaisa friend hai jo sirf excel ka interview deta hai aur uspar bhi saare interview mein reject ho jaata😂😂😂😂
What wonderful 😂😂 comment
bhai 5 mint thak mera hasi nahi rukraha hai apka coment padkar
😂😂😂😂😂😂😂😂
Gajab beizzati hai 😂
Wah bhai bahut khoob subscribed
Wages kese nikale over time ka per day ka. Per hrs ka. Woh bataye
Awesome sir 😮
Hello sir, please tell the formula for hixon crowell cube formula for Excel sheet to get the values.
Ye advance excel ki class hai kya sir
Superb❤❤❤😊
Working ❤
Ek hi sheet par complete month k liye 25 staff ki entry kaise karenge
Please format bataiyega sir
वाह बेटा अपने आप को बहोत बड़े ज्ञानी बन रहे हों, ओ जो इंटरव्यू में फेल हुआ था ओ यही माथर जात था 😊😊😊😊😊
Please expand the formua in fx its not showing
sir isko second cell me.se first cell ko minus krke nhi nikal skte kya
I would be very greatful if you give me a solution to count meals separately Breakfast, lunch, diner from one date to another
for example
Check in date
05-09-2024 LUNCH &
Check out date 09-09-2024 DINER
Formula should count meals like a person had 4nos breakfast (e.g. 6B,7B,8B,9B), 4nos Lunches & 5nos Diners
Only meals count required
Type your comment in chat gpt and it will guide you about everything including the formula and method of applying the formula.
Great🎉
Thora slow sabhi log itana fast nahi samjhte
Thank you
42000 salary ke
12 hrs 10 hrs ya 8 hrs
Per day amount kese nikale
I'm very simple but I will explain that 🤣 the basic salary divide by 30 days then divided by 8 hours
When you try then tell me in comment
=(Out time-in time)-08:00:00
Ye sab HR walo ke liye kaam me aayega sabke liye nahi
Office 365 can you use for this formula
Ok
How can we remember all this formula?
Practice
@@byte_tech are you saying practice and memorize the formula? Is that the only way to know all excel formula?
@@Dorje.T only remember those formula which are of daily use for u. All formulae are already there on the internet..u just need to know how to use.
Ham direct minus ni kr skte kya
Mere me 9 am to 6 om wale 0.041666 is tarh aa rha h aisa kyo video me 1 aay h😊
Bhai us value per right click karke format cell per Jana fir custom select karna and h:mm select karna mns hour and minute fir ajaega
Agar koi workar koch minat Der se Aya he to wo kese hoga
HRMS
Ye formula kaam nhi kr rha h. Overtime me 0.2083 aa rha h. Please explain
जब भी हम कोई date डालते हैं तो jan ही क्यों आता है कोई और month क्यों नहीं आता ❓❓
Itna lamba Kon yaad rakhega
Bhai is ko shot batai
3 - - - matlab kya hai
Paisa hi nhi tha bro pakda to mene bhi pahli chandal se hi tha
Mera nahi hua bro. Value dikhane k bajaye ye time show kar raha hai. Jaise -
Maine ek column mei in time dala hai 9:00Am or out time 5:30 PM. Overtime wale cell mei ye 12:30 Am dikha Raha hai.
12:30 Wale cell ko select karke custom formatting Mai Jake general select kar lo
❤
How can learn this formulas?
Experience se aate h bas use karte jao
Itne easy interview kaha hote hai
=MOD(Timeout -TimeOne,1)*24
Can you explain that easy
Daily Excel m work milta h kya Bhaiya
Nahi Bhai kabhi kabhi 😀
Sahi m daily nhi milta h 😅
Ho sake to product ka expired date nikal kar dikhao
Me who's good at maths : 😈
Bhai 1000 bando ka kar dega kya
@@AbcdEfgh-pu6nq 400 logo ka 1:30 ghante Mein kar dunga... mai C ya cpp ya python program se hi kr dunga... Phir excel mein likh dunga... And programming languages mein 20 minute ke andr 1000 logo ka ho jayega aram se 👌
I was getting some error value
Great bro ❤
Bhaiya mera work nhi krta bhai
Dono ko minus kar k 8 se minus kardo. Kya itna lamba formula
Why its not working
Real job tricks sir
Hello sir me apke video dekh kar overtime nikala par 0.041667 aa raha hai kaise sir please help and reply 🙏
Convert into time format
@@mayurpotdar16597 kaise karna hai sir thoda bata dijiye na
Select time-- then press ctrl+1 -- then go to custom --- remove general --- and type the time format ex. (hh:mm) Then ok
Value is showing in decimal what should I do now 😢
Select all values press ctrl + 1 --> click on custom --> remove general --> type hh:mm --> click ok
Done. Mere me bhi 0.04 is trah aa rha tha fix thanks
Not working , after pressing enter it shows #value!
Formula mein error hoga bhai kahi pe
bhai itz not simply😂
It's not working. I want to make exact as yours but It's not working
What are you getting?
Nhi hua
Wrong easy formula hai ye bahot lamba or wrong hai don't follow pls improve bro
Koshish kiye par nahi aaya
Kya issue aa rha hai?
@@byte_tech formula putap kar raha ho par nahi ho Raha hai
Sala itna bada formula kaun yad rakhega
Practice se yaad rahega
Lol too long trick 😂😂
Ohh to aap bata do short trick
Bade aae dusro ki insult karne wale
Itna drama k badle koi short form nahi hai kya?
Kaise itna formula apply karega banda?