Tap to unmute

How to subtract time in excel | Calculating Time in MS-Excel in hindi | Time subtraction in excel

  Рет қаралды 75,202

Computer Gyan Guruji

Computer Gyan Guruji

Күн бұрын

Пікірлер: 70
@mahetabkhan6955
@mahetabkhan6955 4 жыл бұрын
Gajab sir maza aa gya bahut bahut shukriya allah aapko hamesha khush rakhe.
@vishal21591
@vishal21591 2 жыл бұрын
Zabardast 🔥 sirji mazza aa gaya
@rajanphadke9273
@rajanphadke9273 3 жыл бұрын
Very Nicely Explained the difficult task. Sir i had spent number of hours for solutions. I loved your style of explanation sir Thanks a lot 🙏
@ComputerGyanGuruji
@ComputerGyanGuruji 3 жыл бұрын
Thanks and welcome
@parthasinha2090
@parthasinha2090 4 жыл бұрын
It's so helpful Sir, thanks a lot.
@parthasinha2090
@parthasinha2090 2 жыл бұрын
Thanks Sir, Definitely it's useful for for us
@tuitionmk
@tuitionmk 2 жыл бұрын
सर जी, धन्‍यवाद!
@motilalsaraf5431
@motilalsaraf5431 2 жыл бұрын
VERY VERY USEFUL VIDEO
@rock78785
@rock78785 4 жыл бұрын
Thanks sir, it was helpful.
@ubaidillahmuhammad20
@ubaidillahmuhammad20 4 жыл бұрын
AMAZING. Sir, given the file..
@AmitSinghOfficial-bm6sj
@AmitSinghOfficial-bm6sj 3 жыл бұрын
Very good formula
@ATreasureTroveOfKnowledge
@ATreasureTroveOfKnowledge 2 жыл бұрын
Very good video
@mithudas963
@mithudas963 3 жыл бұрын
Thank you sir
@askgamer6534
@askgamer6534 Жыл бұрын
Thanku sir
@abdulsattar-nt8nr
@abdulsattar-nt8nr Жыл бұрын
very nice
@9826076733
@9826076733 2 жыл бұрын
Best video
@ranjankumar-ew5cf
@ranjankumar-ew5cf 3 жыл бұрын
Thank you
@sikhillalth5719
@sikhillalth5719 3 жыл бұрын
Thank u
@HardiksinhJadeja621
@HardiksinhJadeja621 2 жыл бұрын
Hello Sir Meko 20:57 Time mai se 6:13 Minus karna hai aur iska jo value aaye usme se 2:00 minus karna hai toh kaise minus kare???
@muhammadishaq9779
@muhammadishaq9779 3 жыл бұрын
🤗
@bapin4u
@bapin4u 3 жыл бұрын
how to set a formula : 200/- for work of 8 to 11:59 hours of work and 300 for more than 12 hours of work and Rs.0 for less than 8 hrs of work
@ssecwctslinensolapur4302
@ssecwctslinensolapur4302 2 жыл бұрын
How to add big value of hours i.e. 150:20, 143:50, 107:30 for the period of 31 or more cells as in sum cell it is showing only 00:00. Please help
@muzaffarsyed6999
@muzaffarsyed6999 9 ай бұрын
14:00 me se 15:23 minus kiaisay kery ge 24 Hours me ager hu to
@snehasri7714
@snehasri7714 2 жыл бұрын
Sir agar 1:40 hour ko 400 rupees hoga to ye kese multiply kare kya formula lagega
@awadheshkumar5937
@awadheshkumar5937 Жыл бұрын
need help at substracting time 15:05:16 from 15:03:33
@rajatchaurasia9973
@rajatchaurasia9973 2 жыл бұрын
Concat ya text joint use kr skte hai plz tell
@rajatvvij4841
@rajatvvij4841 3 жыл бұрын
Same date and time case mein difference kaise niklegah. Subtract krne par value error reflects
@tarunsehgal5789
@tarunsehgal5789 3 жыл бұрын
Pls. Tell me about the use of addition of 1 in the upper example
@parthasinha2090
@parthasinha2090 2 жыл бұрын
Sir I need video on date substraction using countaifs, I mean substraction of current date from previous date excluding some special dates = how many days. If you already have, then please send the link.🙏🙏🙏
@gaursachin927
@gaursachin927 2 жыл бұрын
Hours ke bad beech ke day kaise nikale pls bta dijiye urgent hai
@chinmayapanda1588
@chinmayapanda1588 2 жыл бұрын
Dear sir, we r loading wagons. Within 3 hours we have to complete loading. Otherwise we must pay panalty out of 3 hours. How to calculate delay time.
@zxcvasdfg1789
@zxcvasdfg1789 Жыл бұрын
Why we add 1in this formula
@vijayshinde5954
@vijayshinde5954 11 ай бұрын
How to add hours and find due time in date and time
@aminpinjari4070
@aminpinjari4070 2 жыл бұрын
How to subtract 5gm from 10gm in excel sheet and which formula to use
@uppariraghavendra3854
@uppariraghavendra3854 Жыл бұрын
if we have 24 hrs format with out AM /PM how to sub tract
@akashkaran9851
@akashkaran9851 3 жыл бұрын
Sir, ye if wale formule main ye 1+ ka kya mtlb ha..Plz expain
@aayu_style299
@aayu_style299 4 жыл бұрын
Sir yah mobile ke Excel mein hoga
@rohitkumarsingh9593
@rohitkumarsingh9593 3 жыл бұрын
Time me plus karna ho to 10minute
@syedabdulmoeez1736
@syedabdulmoeez1736 Жыл бұрын
agr sir 9.45 hai tou round hour kaisy ayega
@ghazanfarali4545
@ghazanfarali4545 4 жыл бұрын
Dear sir how can add watermark in excell and make callan form plz make a video thanks
@ComputerGyanGuruji
@ComputerGyanGuruji 4 жыл бұрын
Yes, sure
@vaibhavchudasama9680
@vaibhavchudasama9680 Жыл бұрын
1) 8h 30m 2) 3h 45m 3) 6h 50m....plz tell me formula to calculate this time for average.
@cdvnrolay9007
@cdvnrolay9007 4 жыл бұрын
Sir yadi do date ke bich ke mhino ki sankhya pta krna ho to kaise karenge
@ComputerGyanGuruji
@ComputerGyanGuruji 4 жыл бұрын
kzbin.info/www/bejne/l6fadXyiabh4ick
@sohanhmwb611
@sohanhmwb611 4 жыл бұрын
Sir How to do date calculation in excel Example: (A1 cell :08/05/2020) (B1 cell :8days )=(C1 cell:? Date) Pls give me formula
@Altaf_Alam
@Altaf_Alam 2 жыл бұрын
=date(year(a1),month(a1),day(a1)+b1) 😊....it will work👍
@sayed_moin
@sayed_moin 6 ай бұрын
Sir video blur araha h kya samjhe
@vijaysahal4556
@vijaysahal4556 4 жыл бұрын
sir time calculate mein if statement use kra aapne usko clear kro usme +1 kyon use kra
@omprakashojha9698
@omprakashojha9698 3 жыл бұрын
Thanks. Very well explained. My spreadsheet has overtime calculated basis the difference of multiple times. But, PQ pulls the OT data in date and time format. I only want the overtime in hours, minutes and seconds. Please advise how can I do it.
@bittu25
@bittu25 Жыл бұрын
How to calculate the amount with time?
@ComputerGyanGuruji
@ComputerGyanGuruji Жыл бұрын
simple time cell multiply amount cell and change format of result with general format
@soumikb2
@soumikb2 3 жыл бұрын
12AM-6AM=ग्रेड A, 6AM-12PM=ग्रेड B, 12PM-6PM=ग्रेड C, 6PM-12AM=GRADE D Kaise kare
@ComputerGyanGuruji
@ComputerGyanGuruji 3 жыл бұрын
Use CDN Font awesome in website
@soumikb2
@soumikb2 3 жыл бұрын
@@ComputerGyanGuruji Sir ji thora details me boliye
@riddhishaw1481
@riddhishaw1481 4 жыл бұрын
Yahan mujhe baar baar format change karna pad raha hai pl aur koi easy method ho to ..........
@narasimhulukarivemula9622
@narasimhulukarivemula9622 10 ай бұрын
SIRJI, WHY SUCH A EASY IS NOT BEING DONE IN MY COMPUTER? WHAT MAY BE THE REASON, PL GUIDE
@Panjabinetwork
@Panjabinetwork 2 жыл бұрын
How back time 20 mins
@dolldola
@dolldola Жыл бұрын
Sir is there any help that I can get from your end regarding my office day to work on real time basis to prepare reports, if possible you can let me know your email address and fees, its really urgent and your videos really informative for me, if you can help please let me know.
@mahendranachiring
@mahendranachiring 3 жыл бұрын
Please help me for this 62712:00 minus 3424:00 = #value!
@prasenjeetchakladar2723
@prasenjeetchakladar2723 3 жыл бұрын
Sir ager time 10.86 hai to usko kaise correct kare exel pe
@niteshbhatt8414
@niteshbhatt8414 3 жыл бұрын
Sir time calculated toh sahi hai per ager koi employees morning 9 am aaya go or night main 3 am gaya ho toh us ka overtime Kaise niklega?
@bhagyshreepujari1825
@bhagyshreepujari1825 2 жыл бұрын
Same problem sir any solution
@abhijitdatta15
@abhijitdatta15 Жыл бұрын
You are showing the subtract formula of DD-MM-YYYY hh:mm:ss format, but how to subtract MM-DD-YYYY hh:mm:ss format in excel
@mdanisurrahaman8558
@mdanisurrahaman8558 4 жыл бұрын
Sir, 1 din me ek sath 5 admi kam kar raha hei, is time overtime kaise nikalenge.
@ComputerGyanGuruji
@ComputerGyanGuruji 4 жыл бұрын
aap hamara ms excel for beginners tutorial dekhan jisme ham date sambandhit saare formule karwa rahe hain
@mohammadsafiqulislam5779
@mohammadsafiqulislam5779 4 жыл бұрын
1+ que koru app bataya nahi, please explain
@rameshchand1762
@rameshchand1762 Жыл бұрын
01 Apr 23 to 15 Apr 23 how many days 15' 14 tell correct days in Excel
@monikalodhi1212
@monikalodhi1212 2 жыл бұрын
1+ ku kiya gya h
@chinmayapanda1588
@chinmayapanda1588 2 жыл бұрын
Dear sir, we r loading wagons. Within 3 hours we have to complete loading. Otherwise we must pay panalty out of 3 hours. How to calculate delay time.
How to have fun with a child 🤣 Food wrap frame! #shorts
0:21
BadaBOOM!
Рет қаралды 17 МЛН
Calculating Time in MS-Excel || Hindi
14:19
Deepak EduWorld
Рет қаралды 1 МЛН
Excel Formula for Time Elapsed in Days, Hours and Minutes
7:21
Computergaga
Рет қаралды 264 М.
How to Calculate Hours Worked in Excel (Midnight Span)
5:07
Excel Tutorials by EasyClick Academy
Рет қаралды 283 М.
How to have fun with a child 🤣 Food wrap frame! #shorts
0:21
BadaBOOM!
Рет қаралды 17 МЛН