+3 votes
275 views
How to add hours, minutes and seconds in Excel 2019

in Office by (552k points)
reopened | 275 views

1 Answer

+4 votes
Best answer

Display the results of sum of hours, minutes and seconds in Excel 2019

Microsoft Excel 2019 is the new bet that Microsoft has integrated into its popular office suite among millions of users, such as Office, which has numerous functions and integrated formulas through which it will be possible to manage all types of data, both numeric and date. or text..

Exactly within the data to be managed in Excel 2019, there is the time type data . These can come to represent a problem for many users due to the task to be performed on them, especially everything related to the sums of hours, minutes and seconds, since when we must perform this type of sums, if it is the case of multiple cells , it is important to note that for every 60 minutes it will be necessary to add 1 to the sum of the hours. This is why for many users confusion or errors are generated when performing this task.

SUM function in Excel
The subject can get a bit more complex when we have to add up both hours and minutes and seconds, for example, we have the following data in an Excel 2019 spreadsheet: image

In theory we can assume that when using the SUM function Excel Excel 2019 would do the calculation, this is correct except for an error since the final result does not adapt to the generated data, thus, in this case we will use the following formula:

 = SUM (B3: B7) 
The result of this formula is the following. As we can see, it does not adjust to the number of hours worked according to the data generated. image

In TechnoWikis we will explain how to display the correct result of the sum of hours, minutes and seconds in Excel 2019..

To stay up to date, remember to subscribe to our YouTube channel! SUBSCRIBE

Display the results of sum of hours, minutes and seconds in Excel 2019

Step 1

To achieve this, we right click on cell B8, in this case where the result will be generated, and in the expanded list we select the option "Format of cells": image
Step 2

Another option to access this option is by clicking on the icon located in the lower right corner of the "Source" group in the "Start" menu. The following wizard will be displayed and there we should go to the "Number" tab and go to the "Customized" section where we will observe the following scheme:

image

Step 3

From the options displayed, we select the following line:
 [h]: mm: ss 
Step 4

By selecting this option we can automatically see the result displayed in the "Sample" field:

image

Step 5

By clicking on "Accept" we can see that the result is the real sum of hours, minutes and seconds: image

As we see, it is a really simple process that integrates Microsoft Excel 2019 to execute sum of time in your spreadsheets and in this way to achieve real results that will be of great help for the area that requires it and without major complications.


by (3.5m points)
edited

Related questions

+4 votes
1 answer
asked Sep 19, 2019 in Office by backtothefuture (552k points) | 342 views
+5 votes
1 answer
asked Nov 29, 2019 in Office by backtothefuture (552k points) | 368 views
+3 votes
1 answer
asked Oct 3, 2019 in Office by backtothefuture (552k points) | 208 views
+5 votes
1 answer
asked Jun 23, 2019 in Office by backtothefuture (552k points) | 284 views
+5 votes
1 answer
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users