Calculating Time in MS-Excel || Hindi
Вставка
- Опубліковано 25 сер 2024
- 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 ► / deepakeduworld
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
दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें 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
ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP
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.
Thanks for this upload. Was very helpful in resolving my Excel sheet time-related issues. Thanks a lot. ❤
you are a grate teacher.Best of luck dear.LOKESH KUMAR SUMAN ,LECTURER OF MATHS
Love this video. This video is very helpful❤❤now I am able to solve all time related problem
Bahut he achhi video banai hai ap ne, aise he logo ki sahaayta karte rahe 😊❤
Deepak sir you have to did this method on Google sheet nice explain sir I am very impressed to you
👍👍👍 ASAP
Deepak Bhai ke video ko Jo unlike karte Hain wo Deepak Bhai ke information ke baare mein kuchh jaante hi Nahi.
♥️♥️♥️♥️♥️♥️
ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP
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
Thank you so much for this video. You solved my problem.
😊
Yr kasam sy bro ap ka fan bn gaya hu yr itny asan tareeqy sy yr great yr
I am Hong Kong, can’t understand your language but go through this video and find it useful, thank you
Brother you just save me, Thank you👍👍
Very complete and comprehensive explanation
Very informative video.. Thanks.
Bahut din bad video aya hai sir aap ka. Chaliye der aya magar durust aya
😊😊😊😊😊
ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP
aapne wo bta diya jo m last year se nhi kar pa rha tha ...thanks
you explained it in a very ease and simple way.thanks alot sir
Thank u so much sir 😊 aapki yeh video mere liye bahut helpful hua
Bahot badhiya sir,bahot upayogi.👍💜😃
😊
ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP
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.....
This video is very helpful. Thanks Sir ji.
ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP
Love you bro always god bless you
ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP
Superb....amazing You are Great...
😊
Aapka video bahut achcha laga hame
ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP
MANY THANKS
FOR SUCHA A NICE FRUITFUL VIDEOS
ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP
What a explain...sir..mind blowing
ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP
Thank you so much it was very useful for me 😊
Fantastic Deepak Sir. How to calculate years, months and days please make a video as early as possible
Gjb video. Helpful.👍👍👍
😊
Nice video sir
Sir drop down list ka ek video banaye achhe se
Thank you sir
Awesome brother 👍👍
thank you so much bro..very helpful to me.
Thanks, it was really helpful.
Thanks for tutorial. Very helpful
Deepak Bhai Kadak🙏
😊😊😊♥️♥️♥️♥️
Thanks a lot sir...plz make video fr powerpoint..
👍👍
Nice and I am so happy with you
Superb video. Please ek baar isiformat ke saath over time nikaal ke video banaie. Saath me lunch time bhi minus karke.
Thanks
Faredoon
Thanx you so much sir 🥰🙏......
Sir you are also very very exilent
ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP
thank u sir for the video and file
One thing is missing you add break time and than calculate hours etc.
Otherwise very best
I ll publish another attendance with time table... Shortly 🤗
Love you Bro
Excellent, Very well explained.
Thank You Sir Osm Teaching
ua-cam.com/video/pYbQGMbeBV4/v-deo.htmlsi=hIgmi_AMb4jUrQcP
Thank you sir very nice video.
😊😊
Its superb ji
Good
thanks brother for your helping video
Osm video dude😘
Very nice video Bhai saab
😊
Thank you❤
Very good
My best sir
😊
Waiting for this topic from lot of time sir. Thanks
😊♥️👍
All in one 👍
Owtime owtime 😂😂 thankyou for information
Month ka overtime calculate karne ke bare mein bataye ?
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%
Thanks bro
It is great
I was so confused how to calculate the time in and out in excel, thanks for solving my issues
good video sir
😊
thank u sirji..good trick
😊
Sir mera working hours nhi nikl rha hai
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.
As usual, great video deepak ji.
😊😊
Thank you so much 🙏🙏
Daily use. Very nice
Nice you deepak
Thank You Sir
Why you add 1 in formula...plz describe this...proper..
Nice sir
Thanks for this.
Tnqq sir ji❤️🙏
Nice Thanku sir
😊
@@DeepakEduWorld:) :)
Thank You Sir ❤❤
Excellent sir ji
😊
Plz give more sir
Mai sabscripe kardiya haiiiii.
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.
Thank you sir!!
I usually just multiply the result by 24 instead of changing the format same result I.e. with date and time. Calculation
Thank u so much 💓
Ap ki baat hi alg ha
😊♥️
ua-cam.com/video/QnvqVvgh3_8/v-deo.html
Please sir,reply to my comment....
Nice video
Thanks sir
😊😊😊
Thanks for video
Hi Deepak, very helpful video, please could you post a video how to create drop down selection option for date and time
in Excel.
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
Nice learning 👍
Nice video 👌👍
Sir mene ek mail kiyatha day book kiliya..
Okay 👍👍 i ll check
Thank you sir.
WOW Deepak
Thankyou so much sir
Very good
Thanks
😊
Arey sir love u
🇵🇰❤️
I just love your videos ♥️
♥️♥️♥️♥️
Superb
😊
Super excellent
Nice ek dam jakasss
😊
😊
formula to calculate time in google sheet above 24 hrs format. eg number 25 should display 25:00:00