Рет қаралды 362,805
In this video, you will learn how to calculate the sum of time in Excel. We have demonstrated the different approaches to how you can make sure that the calculation you do to perform the sum of time in Excel provides you accurate numbers. With this video, you will be able to calculate and provide accurate results of time without errors.
While doing calculations of time in excel it happens that if you do not select the right format it will simply display the remainder of the time and not the actual value unless you change the format to the specific type.
By the end of this video, you will learn what is that type that will help you to show the accurate values and do the right calculations while performing the sum of time.
Also, focus on the locale information which is demonstrated in this video. If the proper locale is not selected you may not see the desired format with which you are trying to achieve the results shown in this video. As some of the locales do not carry the type of format that is required to achieve this type of output, you will need to change it to get the desired results.
Do not forget to watch the next video that we are going to produce which will help you to calculate the maturity of a given product based on a certain date or the maturity of a contract in a similar manner.
We hope that you are enjoying learning Excel through this Excel learning series videos. We request you kindly share these videos with the people who desire to learn Excel from scratch subscribe to the channel and click on the bell icon to continue receiving notifications about the new videos as and when they are posted to keep up with the learning.
Download the Practice File using: drive.google.c...
Free Excel Data for Practice: onlineknowledg...
This applies to:
Excel 2007 and above
#excelLearningSeries #excel #excel2016 #excelDateFunction #excelShortcuts #exceltime