Among the various tasks and options that we can execute in Excel 2016 such as creating histograms, graphs, filtering data, changing colors according to value, etc. We must know that there is one in particular that is quite important, especially when we are from the HR area, since they manage time (in hours and minutes) on multiple occasions. We are talking about the sum of minutes and hours in Excel since although it seems something quite simple and simple, executing a sum or self sum in many occasions is not enough .
Today Solvetic will teach you how to perform this task in a simple and totally practical way.
The main problem that many people experience when trying to add hours and minutes in Excel 2016 is when it is necessary to add several cells with hours and minutes because for every 60 minutes we must add 1 to the sum of the hours and that is where this task It takes a somewhat complicated course, but at the same time it is necessary to know so that the management and order of time added is correct.
For this case we have the following data:
In this case we must add the total time to be clear how many hours were active. If we used the normal method using the SUMA function we would have the following result:
As we see the result is not consistent with the hours reported and this is the error where many people sadly stay and do not find how to solve it but we will see how to display the correct hours.
It will be necessary to right click on the cell where we have the general formula, in this case B8, and select the Format cells option. In the displayed window we select the Number tab and from the options available on the left side we choose Custom .
There we must choose the following format:
[h]: mm: ssClick Accept to apply the new format. We can see how the new result is as expected:
As we see it is much simpler and more useful than we imagine adding hours and minutes in Excel 2016 . With this knowledge of formula we will see simple and practical time accounting in Excel.
Excel 2016 nested SI function
Articles