Getting SUM for hh mm ss in EXCEL

0 votes

In a document I'm working on, I need to find the SUM of different call time values and assign or display that amount in a total cell. I've included a picture of the data I'm using. The cell receiving the entries is formatted in [hh]:mm:ss, and the entries are in the hh:mm:ss format. The equation is =SUM (C2:C11). Despite adding braces to the format, the totals cell still displays a value of 00:00:00. Can somebody assist me with this? Thank you very much.

enter image description here

Oct 23, 2022 in Others by Kithuzzz
• 38,020 points
6,464 views

1 answer to this question.

0 votes

The times are probably preserved as text.

SUM will disregard the text, so it will return 0.

One possibility is to change the text to a real time, but since the time is already in a format that Excel can understand as a time, we can do it in the formula:

=SUMPRODUCT(--C2:C11)

The -- will force the text into a number and the SUMPRODUCT will iterate the array and sum the results.

With Office 365 we can use SUM:

=SUM(--C2:C11)

Older versions will need to use Ctrl-Shift-Enter if SUM is used instead of SUMPRODUCT which will not require it in any version.

answered Oct 23, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
1,539 views
+1 vote
1 answer

How to use VBA in Excel for Google Search?

Try this: Private Const LicenseRegistration As String = ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 63,720 points
1,620 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,720 points
1,157 views
0 votes
1 answer

Getting subtraction wrong in excel

Solution: If your values are a result of ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,720 points
1,695 views
0 votes
1 answer

Add .xll as AddIn to Excel

Hi, for adding an xll as Addln ...READ MORE

answered Feb 17, 2022 in Others by gaurav
• 23,260 points
1,153 views
0 votes
1 answer

Group by Sum in Excel

It is very easy and you can ...READ MORE

answered Feb 21, 2022 in Database by gaurav
• 23,260 points
547 views
0 votes
1 answer

JavaScript API does not work for Excel 2013?

Each method in the Office.js APIs is ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 63,720 points
691 views
0 votes
1 answer

Excel COUNTIF formula

Please see MS Excel: COUNTIF Function (WS) You should ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
• 63,720 points
739 views
0 votes
1 answer

How to sum time in Excel?

Assuming your data is located at [D12:D22] Try this ...READ MORE

answered Sep 27, 2022 in Others by narikkadan
• 63,720 points
11,844 views
0 votes
1 answer

An error for excel download in Firefox for JMeter script recording

You shouldn't just copy and paste configuration ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
• 63,720 points
816 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP