@@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 👌
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.
![Advance 🔥 Filter in EXCEL | Excel Interview | MS Excel [Hindi]](http://i.ytimg.com/vi/HGLDKwNaszw/mqdefault.jpg)
![Advance 🔥 Filter in EXCEL | Excel Interview | MS Excel [Hindi]](/img/tr.png)
Itna yaad kis ko raheta h 😂
Best things of this video you explained fully formula
Bhut mst padhaya
Awesome sir 😮
Superb❤❤❤😊
Ye tumhara kaisa friend hai jo sirf excel ka interview deta hai aur uspar bhi saare interview mein reject ho jaata😂😂😂😂
What wonderful 😂😂 comment
Wah bhai bahut khoob subscribed
Great🎉
Working ❤
❤
Please expand the formua in fx its not showing
Thank you
Ek hi sheet par complete month k liye 25 staff ki entry kaise karenge
Please format bataiyega sir
Ye advance excel ki class hai kya sir
sir isko second cell me.se first cell ko minus krke nhi nikal 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
Ye formula kaam nhi kr rha h. Overtime me 0.2083 aa rha h. Please explain
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 👌
Agar koi workar koch minat Der se Aya he to wo kese hoga
Paisa hi nhi tha bro pakda to mene bhi pahli chandal se hi tha
Office 365 can you use for this formula
Ok
Great bro ❤
=MOD(Timeout -TimeOne,1)*24
Can you explain that easy
Itne easy interview kaha hote hai
Ham direct minus ni kr skte kya
जब भी हम कोई date डालते हैं तो jan ही क्यों आता है कोई और month क्यों नहीं आता ❓❓
3 - - - matlab kya hai
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
Real job tricks sir
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
I was getting some error value
Daily Excel m work milta h kya Bhaiya
Nahi Bhai kabhi kabhi 😀
Sahi m daily nhi milta h 😅
Why its not working
Dono ko minus kar k 8 se minus kardo. Kya itna lamba formula
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
bhai itz not simply😂
Not working , after pressing enter it shows #value!
Formula mein error hoga bhai kahi pe
It's not working. I want to make exact as yours but It's not working
What are you getting?
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
Lol too long trick 😂😂
Ohh to aap bata do short trick
Bade aae dusro ki insult karne wale
Sala itna bada formula kaun yad rakhega
Practice se yaad rahega
Itna drama k badle koi short form nahi hai kya?
Kaise itna formula apply karega banda?