Calculating Time in MS-Excel || Hindi

Поделиться
HTML-код
  • Опубликовано: 9 окт 2019
  • 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.com/open?id=1ldt...
    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

Комментарии • 519

  • @DeepakEduWorld
    @DeepakEduWorld  3 года назад +11

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

  • @wealthinstocks8480
    @wealthinstocks8480 13 дней назад +1

    Very informative video.. Thanks.

  • @afnanforyou
    @afnanforyou 4 года назад +1

    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.

  • @DeepakEduWorld
    @DeepakEduWorld  4 года назад +7

    *Doston NEW videos ke liye Subscribe kare bell icon bhi press kar le ... Purane videos ke liye playlists dekhe .. links description main hain* 😊

    • @haniabatool2452
      @haniabatool2452 4 года назад

      Apki sb videos are so much helpful and easy words

  • @souvikchakrabortty3493
    @souvikchakrabortty3493 2 месяца назад +1

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

  • @raghurajsir5479
    @raghurajsir5479 2 месяца назад +1

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

  • @sikandarmohd6664
    @sikandarmohd6664 4 дня назад

    Thank you so much it was very useful for me 😊

  • @lokeshsuman7383
    @lokeshsuman7383 4 года назад +2

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

  • @rajurangeela5573
    @rajurangeela5573 4 года назад +2

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

  • @vahidjannati4622
    @vahidjannati4622 2 года назад +1

    Very complete and comprehensive explanation

  • @faizankhan-vp4ne
    @faizankhan-vp4ne 3 года назад +1

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

  • @starmanish3427
    @starmanish3427 6 месяцев назад +1

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

  • @satyamthepassionate5430
    @satyamthepassionate5430 4 года назад +5

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

  • @sujoysarkar9249
    @sujoysarkar9249 4 года назад +2

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

  • @digitalmarketingtipps
    @digitalmarketingtipps 17 дней назад

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

  • @globalgroup6584
    @globalgroup6584 2 года назад +1

    This video is very helpful. Thanks Sir ji.

  • @giftsonchintalu5021
    @giftsonchintalu5021 2 года назад +1

    What a explain...sir..mind blowing

  • @rajeevgosavi4514
    @rajeevgosavi4514 2 года назад

    Excellent, Very well explained.

  • @NamoriTravelandTours
    @NamoriTravelandTours Год назад +1

    MANY THANKS
    FOR SUCHA A NICE FRUITFUL VIDEOS

  • @lifeonwheels8420
    @lifeonwheels8420 2 года назад +1

    Love you bro always god bless you

  • @komalvarmaji4813
    @komalvarmaji4813 3 года назад +1

    Aapka video bahut achcha laga hame

  • @kwokbear4359
    @kwokbear4359 2 года назад

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

  • @pranavpratap6056
    @pranavpratap6056 2 года назад

    Brother you just save me, Thank you👍👍

  • @UsmanButt-gp9wi
    @UsmanButt-gp9wi 3 года назад

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

  • @foolmahn797
    @foolmahn797 Год назад

    Thanks for tutorial. Very helpful

  • @ankitanurag256
    @ankitanurag256 2 года назад +1

    Thank You Sir Osm Teaching

  • @raghuveersengar
    @raghuveersengar Год назад

    Thanks, it was really helpful.

  • @Taymul_Choudhury
    @Taymul_Choudhury 3 года назад +1

    Sir you are also very very exilent

  • @vinodvadgama9898
    @vinodvadgama9898 4 года назад +1

    Bahot badhiya sir,bahot upayogi.👍💜😃

  • @pramoddash1435
    @pramoddash1435 2 года назад

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

  • @afzalzamiransari
    @afzalzamiransari 4 года назад +1

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

  • @digvijaysinghchandrawat4404
    @digvijaysinghchandrawat4404 4 года назад

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

  • @SitaRam-fj1nr
    @SitaRam-fj1nr 4 года назад

    Nice and I am so happy with you

  • @NavneetKumar-wf4pl
    @NavneetKumar-wf4pl 11 месяцев назад +1

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

  • @bhogendrasah8193
    @bhogendrasah8193 4 года назад

    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.....

  • @vinaydadhich
    @vinaydadhich 4 года назад +1

    Gjb video. Helpful.👍👍👍

  • @jagdishkataria8315
    @jagdishkataria8315 4 года назад +1

    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.

  • @Rajesh-ul1oi
    @Rajesh-ul1oi 6 месяцев назад

    thanks brother for your helping video

  • @KnowledgeSharing_AbhinavPrasad
    @KnowledgeSharing_AbhinavPrasad 4 года назад

    As usual, great video deepak ji.

  • @avdheshanand8859
    @avdheshanand8859 2 года назад +2

    Month ka overtime calculate karne ke bare mein bataye ?

  • @dayashankaryadav3189
    @dayashankaryadav3189 4 года назад +1

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

  • @bazigarfromyt
    @bazigarfromyt Год назад

    thank u sir for the video and file

  • @dakshkumar873
    @dakshkumar873 2 года назад +1

    Thank you sir.

  • @rohitsisodiya3306
    @rohitsisodiya3306 2 года назад +1

    Awesome brother 👍👍

  • @nandreraju5439
    @nandreraju5439 2 года назад +1

    Nice you deepak

  • @mukulsujal8443
    @mukulsujal8443 4 года назад +1

    Osm video dude😘

  • @beingodishamotivation
    @beingodishamotivation 4 года назад +1

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

  • @Rajinderverma65
    @Rajinderverma65 4 года назад +1

    Thank you sir very nice video.

  • @asiftahashildar
    @asiftahashildar 4 года назад +1

    thank u sirji..good trick

  • @K.DreelCreator
    @K.DreelCreator 3 месяца назад +1

    Thank you❤

  • @shambhupaswan6556
    @shambhupaswan6556 3 года назад

    Daily use. Very nice

  • @MrPZAHOOR
    @MrPZAHOOR 3 года назад

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

  • @raghuv7114
    @raghuv7114 4 года назад +1

    Its superb ji

  • @MrRanjitsihag
    @MrRanjitsihag 4 года назад +1

    Very nice video Bhai saab

  • @rajmangalkraadarsh7396
    @rajmangalkraadarsh7396 3 года назад +1

    Love you Bro

  • @saqlainshaikh9936
    @saqlainshaikh9936 4 года назад +1

    Deepak Bhai Kadak🙏

  • @197319730421
    @197319730421 Год назад

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

  • @purnimakundu1239
    @purnimakundu1239 11 месяцев назад +1

    Plz give more sir

  • @zindaa_laash
    @zindaa_laash 2 года назад

    Tnqq sir ji❤️🙏

  • @motivationalthoughts7452
    @motivationalthoughts7452 2 года назад

    Thank you so much 🙏🙏

  • @gunindradas8042
    @gunindradas8042 4 года назад +1

    Waiting for this topic from lot of time sir. Thanks

  • @jagdishsonje516
    @jagdishsonje516 4 года назад +1

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

  • @uagrahat
    @uagrahat 10 месяцев назад +1

    Thanks for this.

  • @rakeshinfotech7296
    @rakeshinfotech7296 4 года назад +1

    Very good
    My best sir

  • @rheapeter9709
    @rheapeter9709 Год назад

    Thank you sir!!

  • @shahab7460
    @shahab7460 Год назад +1

    All in one 👍

  • @avinashkangia9246
    @avinashkangia9246 4 года назад

    Thank you sir 👌

  • @DeepakRajput-hj2us
    @DeepakRajput-hj2us Год назад

    Thank You Sir ❤❤

  • @rishibhalla9545
    @rishibhalla9545 4 года назад +1

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

  • @jbsumant4929
    @jbsumant4929 Год назад +1

    Thanks bro

  • @briansoanis
    @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
    @atulkumarpandey7097 3 года назад

    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

  • @abuzargifarijony
    @abuzargifarijony Год назад +1

    It is great

  • @pari-techfinance
    @pari-techfinance 4 года назад +5

    Sir
    फॉर्मूला मे 1+ क्यू किया
    आपने ये नही समझाया

  • @rajeshchoudhary2520
    @rajeshchoudhary2520 3 года назад +1

    Thank You Sir

    • @lokeshkumar4882
      @lokeshkumar4882 3 года назад

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

  • @dheerajn8794
    @dheerajn8794 2 года назад

    Thank u so much 💓

  • @MNkhan47755
    @MNkhan47755 4 года назад +2

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

    • @DeepakEduWorld
      @DeepakEduWorld  4 года назад

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

  • @SANDEEPYADAV-uf7rs
    @SANDEEPYADAV-uf7rs 4 года назад +1

    थैंक यू सर

  • @standoff2battlelive197
    @standoff2battlelive197 4 года назад

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

  • @sawankumar7896
    @sawankumar7896 3 года назад

    Thankyou so much sir

  • @sujit1920
    @sujit1920 Год назад

    Nice learning 👍

  • @shivrajhardu5279
    @shivrajhardu5279 4 года назад +1

    Nice video
    Thanks sir

  • @ZahidKhan-gs6xy
    @ZahidKhan-gs6xy 4 года назад +6

    Ap ki baat hi alg ha

  • @ayeshaKhan-dd4dg
    @ayeshaKhan-dd4dg 4 года назад +1

    Nice Thanku sir

  • @makarandkadam9457
    @makarandkadam9457 4 года назад

    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.

  • @laxmanpawar9098
    @laxmanpawar9098 Год назад +1

    Nice sir

  • @rajeshsinghjadham9899
    @rajeshsinghjadham9899 4 года назад +1

    good video sir

  • @vijayvarma6164
    @vijayvarma6164 4 года назад +1

    I just love your videos ♥️

  • @Dk05216
    @Dk05216 2 года назад +2

    Deepak sir batch time pe video bnaye you request me🙏🙏

  • @artikadevi5181
    @artikadevi5181 3 года назад

    Thank you sir 🙏

  • @RajaVerma-fm9er
    @RajaVerma-fm9er 27 дней назад +3

    Sir mera working hours nhi nikl rha hai

  • @rajeshkumarprajapat6882
    @rajeshkumarprajapat6882 4 года назад +1

    Very good
    Thanks

  • @gouravdixit8673
    @gouravdixit8673 4 года назад +1

    Excellent sir ji

  • @jatinyadav1717
    @jatinyadav1717 9 месяцев назад +1

    Sir now formula ka Attendance sheet men kaise use karen jo ki har employee Ka coming time and out time so kare

  • @godamolyt5165
    @godamolyt5165 Год назад

    Tq so mach sir

  • @kskinglysolutions1301
    @kskinglysolutions1301 29 дней назад +1

    How to deal the off day in working hour calculation?

  • @NN-lp4ge
    @NN-lp4ge 5 месяцев назад +1

    24 hrs se zada k liye konsa formula lagega format cell me...plz btaye

  • @pratickdas6544
    @pratickdas6544 15 дней назад

    thank you sir

  • @waqarvicky9769
    @waqarvicky9769 Год назад

    Arey sir love u
    🇵🇰❤️

  • @sherazrathoor8552
    @sherazrathoor8552 4 года назад +1

    Kuch nya sekhy sir excel smj agya sir