Calculating Time in MS-Excel || Hindi

About Video
How to calculate time in excel. in this excel hindi time calculating tutorial you will learn how we can easily calculate time difference in excel between 2 times and two dates this video by deepak eduworld explain how we can calculate date & time difference in excel. calculate hours and minutes between two times & two dates.
doston is video mai maine btaya hai ki microsoft excel main hum time kaise calculate kartey hain. do times ke beech main hours kaise calculate krange, hours ka sum kaise krange, do dates ke beech main hourse kaise nikalange. ummeed karta hun ye video apko pasand jarur aayega friends.
Download Training File drive.google.c...
Sumif formula : • SUMIF formula in excel...
if formula • IF Logical Function in...
iferror formula • How to use IFERROR for...
Attendance sheet Video : • How to Maintain Attend...
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld​​
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld​
LinkedIn ► / deepakeduworld
Facebook Group ► / deepakedu​​world
Thanks for watching #deepakeduworld​​​
calculating time in ms-excel,microsoft excel,time,how to calculate time in excel,excel tips,hours,excel tricks,timesheet,sum hours,excel in hindi,learn excel in hindi,time formula,time difference,sum of time,sum time in excel,excel tutorial,attendance sheet in excel,pivot table excel,deepak eduworld,excel tips and tricks,excel user,advanced excel

[@DeepakEduWorld]

दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰
*My New Channel :* bit.ly/3qFrbl5
*Complete Microsoft Word Tutorial :* ua-cam.com/video/Xkq0-xXAj48/v-deo.html
*Complete Powerpoint Tutorial :* ua-cam.com/video/OekrBhNybP0/v-deo.html
*Xlookup Complete Tutorial :* ua-cam.com/video/0LjfRVD7srU/v-deo.html
*Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
*Excel All Formulas :* ua-cam.com/video/C9y53fedo04/v-deo.html

[@ramkishoryadav9087]

ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP

[@afnanforyou]

Woh third example mein helper cells ki zarurat nahi hain aggar aap total hours k cell mein following formula daalte hain to
=(ED+ET)-(SD+ST) = Total Hours.
Isse bhi kaam chal sakta hain lekin aapne bohut he badiya explain kiya. Yeh uppar wala formula advance excel users k leye hain.

[@raghurajsir5479]

Thanks for this upload. Was very helpful in resolving my Excel sheet time-related issues. Thanks a lot. ❤

[@lokeshsuman7383]

you are a grate teacher.Best of luck dear.LOKESH KUMAR SUMAN ,LECTURER OF MATHS

[@souvikchakrabortty3493]

Love this video. This video is very helpful❤❤now I am able to solve all time related problem

[@starmanish3427]

Bahut he achhi video banai hai ap ne, aise he logo ki sahaayta karte rahe 😊❤

[@sujoysarkar9249]

Deepak sir you have to did this method on Google sheet nice explain sir I am very impressed to you

[@DeepakEduWorld]

👍👍👍 ASAP

[@rajurangeela5573]

Deepak Bhai ke video ko Jo unlike karte Hain wo Deepak Bhai ke information ke baare mein kuchh jaante hi Nahi.

[@DeepakEduWorld]

♥️♥️♥️♥️♥️♥️

[@ramkishoryadav9087]

ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP

[@neetukumari6731]

Ye sab to institute me bhi nahi dikhaya tha ab interview me jate hi reject ho jati apka video dekh kar sikh liya thank you so much sir

[@satyamthepassionate5430]

Thank you so much for this video. You solved my problem.

[@DeepakEduWorld]

😊

[@UsmanButt-gp9wi]

Yr kasam sy bro ap ka fan bn gaya hu yr itny asan tareeqy sy yr great yr

[@kwokbear4359]

I am Hong Kong, can’t understand your language but go through this video and find it useful, thank you

[@pranavpratap6056]

Brother you just save me, Thank you👍👍

[@vahidjannati4622]

Very complete and comprehensive explanation

[@wealthinstocks8480]

Very informative video.. Thanks.

[@afzalzamiransari]

Bahut din bad video aya hai sir aap ka. Chaliye der aya magar durust aya

[@DeepakEduWorld]

😊😊😊😊😊

[@ramkishoryadav9087]

ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP

[@digvijaysinghchandrawat4404]

aapne wo bta diya jo m last year se nhi kar pa rha tha ...thanks

[@faizankhan-vp4ne]

you explained it in a very ease and simple way.thanks alot sir

[@pramoddash1435]

Thank u so much sir 😊 aapki yeh video mere liye bahut helpful hua

[@vinodvadgama9898]

Bahot badhiya sir,bahot upayogi.👍💜😃

[@DeepakEduWorld]

😊

[@ramkishoryadav9087]

ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP

[@bhogendrasah8193]

Dear Deepak Ji,
I am from Nepal, It was very useful and interesting video for me, I am your regular viewer and Please, keep it up...... as you are the best excel guru..... thanks alot....sir.....

[@globalgroup6584]

This video is very helpful. Thanks Sir ji.

[@ramkishoryadav9087]

ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP

[@lifeonwheels8420]

Love you bro always god bless you

[@ramkishoryadav9087]

ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP

[@dayashankaryadav3189]

Superb....amazing You are Great...

[@DeepakEduWorld]

😊

[@komalvarmaji4813]

Aapka video bahut achcha laga hame

[@ramkishoryadav9087]

ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP

[@NamoriTravelandTours]

MANY THANKS
FOR SUCHA A NICE FRUITFUL VIDEOS

[@ramkishoryadav9087]

ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP

[@giftsonchintalu5021]

What a explain...sir..mind blowing

[@ramkishoryadav9087]

ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP

[@sikandarmohd6664]

Thank you so much it was very useful for me 😊

[@MrPZAHOOR]

Fantastic Deepak Sir. How to calculate years, months and days please make a video as early as possible

[@vinaydadhich]

Gjb video. Helpful.👍👍👍

[@DeepakEduWorld]

😊

[@beingodishamotivation]

Nice video sir
Sir drop down list ka ek video banaye achhe se
Thank you sir

[@rohitsisodiya3306]

Awesome brother 👍👍

[@digitalmarketingtipps]

thank you so much bro..very helpful to me.

[@raghuveersengar]

Thanks, it was really helpful.

[@foolmahn797]

Thanks for tutorial. Very helpful

[@saqlainshaikh9936]

Deepak Bhai Kadak🙏

[@DeepakEduWorld]

😊😊😊♥️♥️♥️♥️

[@jagdishsonje516]

Thanks a lot sir...plz make video fr powerpoint..

[@DeepakEduWorld]

👍👍

[@SitaRam-fj1nr]

Nice and I am so happy with you

[@standoff2battlelive197]

Superb video. Please ek baar isiformat ke saath over time nikaal ke video banaie. Saath me lunch time bhi minus karke.
Thanks
Faredoon

[@NavneetKumar-wf4pl]

Thanx you so much sir 🥰🙏......

[@Taymul_Choudhury]

Sir you are also very very exilent

[@ramkishoryadav9087]

ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP

[@bazigarfromyt]

thank u sir for the video and file

[@MNkhan47755]

One thing is missing you add break time and than calculate hours etc.
Otherwise very best

[@DeepakEduWorld]

I ll publish another attendance with time table... Shortly 🤗

[@rajmangalkraadarsh7396]

Love you Bro

[@rajeevgosavi4514]

Excellent, Very well explained.

[@ankitanurag256]

Thank You Sir Osm Teaching

[@ramkishoryadav9087]

ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP

[@Rajinderverma65]

Thank you sir very nice video.

[@DeepakEduWorld]

😊😊

[@raghuv7114]

Its superb ji

[@ZainAliTech786]

Good

[@Rajesh-ul1oi]

thanks brother for your helping video

[@mukulsujal8443]

Osm video dude😘

[@MrRanjitsihag]

Very nice video Bhai saab

[@DeepakEduWorld]

😊

[@K.DreelCreator]

Thank you❤

[@rakeshinfotech7296]

Very good
My best sir

[@DeepakEduWorld]

😊

[@gunindradas8042]

Waiting for this topic from lot of time sir. Thanks

[@DeepakEduWorld]

😊♥️👍

[@shahab7460]

All in one 👍

[@sainath58]

Owtime owtime 😂😂 thankyou for information

[@avdheshanand8859]

Month ka overtime calculate karne ke bare mein bataye ?

[@maheshurdhwareshe7494]

Dipak sir which formula use to know the range between two values For example- less than equal to 99.0% & more than equal to 101.5%

[@jbsumant4929]

Thanks bro

[@abuzargifarijony]

It is great

[@197319730421]

I was so confused how to calculate the time in and out in excel, thanks for solving my issues

[@rajeshsinghjadham9899]

good video sir

[@DeepakEduWorld]

😊

[@asiftahashildar]

thank u sirji..good trick

[@DeepakEduWorld]

😊

[@RajaVerma-fm9er]

Sir mera working hours nhi nikl rha hai

[@jagdishkataria8315]

Hi Deepak, it is a great video and helped me out amazingly. I have a query how to check if one time slab crosses another time slab. For example employee no 1 work on a date with in a shift of 9 to 5, and if by mistake in same sheet entered wrongly the same employee work in a shift of 2 to 10 than it must show an error that employee is already working in shift of 9 to 5. Please help.

[@KnowledgeSharing_AbhinavPrasad]

As usual, great video deepak ji.

[@DeepakEduWorld]

😊😊

[@motivationalthoughts7452]

Thank you so much 🙏🙏

[@shambhupaswan6556]

Daily use. Very nice

[@nandreraju5439]

Nice you deepak

[@rajeshchoudhary2520]

Thank You Sir

[@lokeshkumar4882]

Why you add 1 in formula...plz describe this...proper..

[@laxmanpawar9098]

Nice sir

[@uagrahat]

Thanks for this.

[@zindaa_laash]

Tnqq sir ji❤️🙏

[@ayeshaKhan-dd4dg]

Nice Thanku sir

[@DeepakEduWorld]

😊

[@ayeshaKhan-dd4dg]

@@DeepakEduWorld:) :)

[@DeepakRajput-hj2us]

Thank You Sir ❤❤

[@gouravdixit8673]

Excellent sir ji

[@DeepakEduWorld]

😊

[@purnimakundu1239]

Plz give more sir

[@user-kw1dp6nn7y]

Mai sabscripe kardiya haiiiii.

[@makarandkadam9457]

Hello Deepak Sir. It's really working idea's you gave in Excel time calculation video. Can you pls tell me if I want to find time when date change like
18.00 hrs to next day 06.00 hrs
Like this without converting it to AM PM form. Can I simply apply any formula to this.
And if we goes for minutes like
10.45 hrs to 18.15 hrs will it work.
Waiting for your reply Sir.
Thank You for such information.

[@rheapeter9709]

Thank you sir!!

[@rishibhalla9545]

I usually just multiply the result by 24 instead of changing the format same result I.e. with date and time. Calculation

[@dheerajn8794]

Thank u so much 💓

[@ZahidKhan-gs6xy]

Ap ki baat hi alg ha

[@DeepakEduWorld]

😊♥️

[@Justknowledge_Excel]

ua-cam.com/video/QnvqVvgh3_8/v-deo.html

[@azmals.m5756]

Please sir,reply to my comment....

[@shivrajhardu5279]

Nice video
Thanks sir

[@DeepakEduWorld]

😊😊😊

[@ankursinghsaini8154]

Thanks for video

[@briansoanis]

Hi Deepak, very helpful video, please could you post a video how to create drop down selection option for date and time
in Excel.

[@atulkumarpandey7097]

Hi Deepak,
Your video is really amazing and I learn lots of new things.
I need your help on 1 query.
Hope If you prepare video on the same.
I need date difference where, time format is written in in single column.
For eg,
7:00 AM- 7 PM
Above time is written in single cell in whole 1 column.
I need working hr of it in another coloum .
Please help

[@sujit1920]

Nice learning 👍

[@badripatra2504]

Nice video 👌👍
Sir mene ek mail kiyatha day book kiliya..

[@DeepakEduWorld]

Okay 👍👍 i ll check

[@dakshkumar873]

Thank you sir.

[@RehanKhan-tc1xp]

WOW Deepak

[@sawankumar7896]

Thankyou so much sir

[@rajeshkumarprajapat6882]

Very good
Thanks

[@DeepakEduWorld]

😊

[@WAQAR_VICKY-W]

Arey sir love u
🇵🇰❤️

[@Vjvrma]

I just love your videos ♥️

[@DeepakEduWorld]

♥️♥️♥️♥️

[@fakreaalam7722]

Superb

[@DeepakEduWorld]

😊

[@satyamsr7851]

Super excellent

[@kishorpanara4191]

Nice ek dam jakasss

[@DeepakEduWorld]

😊

[@DeepakEduWorld]

😊

[@user-ox3od8zz5s]

formula to calculate time in google sheet above 24 hrs format. eg number 25 should display 25:00:00