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 ► / 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 :* 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
Very informative video.. Thanks.
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.
*Doston NEW videos ke liye Subscribe kare bell icon bhi press kar le ... Purane videos ke liye playlists dekhe .. links description main hain* 😊
Apki sb videos are so much helpful and easy words
Love this video. This video is very helpful❤❤now I am able to solve all time related problem
Thanks for this upload. Was very helpful in resolving my Excel sheet time-related issues. Thanks a lot. ❤
Thank you so much it was very useful for me 😊
you are a grate teacher.Best of luck dear.LOKESH KUMAR SUMAN ,LECTURER OF MATHS
Deepak Bhai ke video ko Jo unlike karte Hain wo Deepak Bhai ke information ke baare mein kuchh jaante hi Nahi.
♥️♥️♥️♥️♥️♥️
Very complete and comprehensive explanation
you explained it in a very ease and simple way.thanks alot sir
Bahut he achhi video banai hai ap ne, aise he logo ki sahaayta karte rahe 😊❤
Thank you so much for this video. You solved my problem.
😊
Deepak sir you have to did this method on Google sheet nice explain sir I am very impressed to you
👍👍👍 ASAP
thank you so much bro..very helpful to me.
This video is very helpful. Thanks Sir ji.
What a explain...sir..mind blowing
Excellent, Very well explained.
MANY THANKS
FOR SUCHA A NICE FRUITFUL VIDEOS
Love you bro always god bless you
Aapka video bahut achcha laga hame
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👍👍
Yr kasam sy bro ap ka fan bn gaya hu yr itny asan tareeqy sy yr great yr
Thanks for tutorial. Very helpful
Thank You Sir Osm Teaching
Thanks, it was really helpful.
Sir you are also very very exilent
Bahot badhiya sir,bahot upayogi.👍💜😃
😊
Thank u so much sir 😊 aapki yeh video mere liye bahut helpful hua
Bahut din bad video aya hai sir aap ka. Chaliye der aya magar durust aya
😊😊😊😊😊
aapne wo bta diya jo m last year se nhi kar pa rha tha ...thanks
Nice and I am so happy with you
Thanx you so much sir 🥰🙏......
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.....
Gjb video. Helpful.👍👍👍
😊
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.
thanks brother for your helping video
As usual, great video deepak ji.
😊😊
Month ka overtime calculate karne ke bare mein bataye ?
Superb....amazing You are Great...
😊
thank u sir for the video and file
Thank you sir.
Awesome brother 👍👍
Nice you deepak
Osm video dude😘
Nice video sir
Sir drop down list ka ek video banaye achhe se
Thank you sir
Thank you sir very nice video.
😊😊
thank u sirji..good trick
😊
Thank you❤
Daily use. Very nice
Fantastic Deepak Sir. How to calculate years, months and days please make a video as early as possible
Its superb ji
Very nice video Bhai saab
😊
Love you Bro
Deepak Bhai Kadak🙏
😊😊😊♥️♥️♥️♥️
I was so confused how to calculate the time in and out in excel, thanks for solving my issues
Plz give more sir
Tnqq sir ji❤️🙏
Thank you so much 🙏🙏
Waiting for this topic from lot of time sir. Thanks
😊♥️👍
Thanks a lot sir...plz make video fr powerpoint..
👍👍
Thanks for this.
Very good
My best sir
😊
Thank you sir!!
All in one 👍
Thank you sir 👌
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
Thanks bro
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
It is great
Sir
फॉर्मूला मे 1+ क्यू किया
आपने ये नही समझाया
Thank You Sir
Why you add 1 in formula...plz describe this...proper..
Thank u so much 💓
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 🤗
थैंक यू सर
😊
Superb video. Please ek baar isiformat ke saath over time nikaal ke video banaie. Saath me lunch time bhi minus karke.
Thanks
Faredoon
Thankyou so much sir
Nice learning 👍
Nice video
Thanks sir
😊😊😊
Ap ki baat hi alg ha
😊♥️
ruclips.net/video/QnvqVvgh3_8/видео.html
Please sir,reply to my comment....
Nice Thanku sir
😊
@@DeepakEduWorld:) :)
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.
Nice sir
good video sir
😊
I just love your videos ♥️
♥️♥️♥️♥️
Deepak sir batch time pe video bnaye you request me🙏🙏
Thank you sir 🙏
Sir mera working hours nhi nikl rha hai
Very good
Thanks
😊
Excellent sir ji
😊
Sir now formula ka Attendance sheet men kaise use karen jo ki har employee Ka coming time and out time so kare
Tq so mach sir
How to deal the off day in working hour calculation?
24 hrs se zada k liye konsa formula lagega format cell me...plz btaye
thank you sir
Arey sir love u
🇵🇰❤️
Kuch nya sekhy sir excel smj agya sir