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 in Others by Kithuzzz
• 20,660 points
84 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 by narikkadan
• 37,660 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 in Others by gaurav
• 22,040 points
531 views
0 votes
1 answer

How to use VBA in Excel for Google Search?

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

answered Oct 7 in Others by narikkadan
• 37,660 points
138 views
0 votes
1 answer
0 votes
1 answer

Getting subtraction wrong in excel

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

answered Oct 10 in Others by narikkadan
• 37,660 points
44 views
0 votes
1 answer

Add .xll as AddIn to Excel

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

answered Feb 17 in Others by gaurav
• 22,040 points
124 views
0 votes
1 answer

Group by Sum in Excel

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

answered Feb 21 in Database by gaurav
• 22,040 points
140 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 in Others by narikkadan
• 37,660 points
50 views
0 votes
1 answer

Excel COUNTIF formula

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

answered Sep 29 in Others by narikkadan
• 37,660 points
60 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 in Others by narikkadan
• 37,660 points
93 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 in Others by narikkadan
• 37,660 points
90 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