How to sum time in Excel

0 votes

I got a range of cells in an Excel file with values of time like "12:00" (hh: mm), which is stored as plain text, without specific cell formatting. I need to sum up all of the cells, but I got zero when I try the SUM function.
How can I get the total sum of a range of cells in the form "hhh:mm: ss"?

Sep 26 in Others by Kithuzzz
• 20,660 points
98 views

1 answer to this question.

0 votes

Assuming your data is located at [D12:D22]

enter image description here

Try this formulas:

  • To convert a time in the form of text to a serial number use this formula:
    = TIMEVALUE(D12)

  • To add time entered as a number use this formula:
    =SUM(E12:E22) and format the cell as: [hh]:mm:ss

  • To add time entered as text use this formula array:
    = SUM( TIMEVALUE(D$12:D$22) ) and format the cell as: [hh]:mm:ss

enter image description here

answered Sep 27 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to open .xlsx files in MS Excel from VS Code?

Hello, to open xlxs files, or files ...READ MORE

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

How to import excel file in Oracle SQL live

Hello, there are a few steps You'll ...READ MORE

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

How to get current time and date in Android

In order to get the current date ...READ MORE

answered Feb 23 in Others by Aditya
• 7,660 points
742 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24 in Others by narikkadan
• 37,660 points
131 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
145 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
248 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
112 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

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

How to get sum of all matches of HLOOKUP in Excel?

Consider: =SUMPRODUCT((A1:E1="apple")*(A2:E2)) To include more ...READ MORE

answered Oct 16 in Others by narikkadan
• 37,660 points
80 views
0 votes
1 answer
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