Sum of time (HH:MM:SS)

[Welsh Mark3]

I have a column of data in Excel that is HH:MM:SS format, for example, 0:30:42 (thirty minutes forty-two seconds), When using the formula =SUM(b2:b3), I get zero value. If I do B2+B3 I get a result.


Is there another formula/function to add time values?

 

[DRSteele]

I think this might help.

Also, check out this info from Microsoft.

And this is a deep summary of number formatting. This one lets you practice.

Book1
	H	I
7	duration	cumulative duration
8	0:30:42	0:30:42
9	0:47:17	1:17:59
10	0:05:08	1:23:07
11	1:23:07
12
13	number format:	[h]:mm:ss;@
Sheet1

Cell Formulas
Range	Formula
I8:I10	I8	=H8+N(I7)
H11	H11	=SUM(H8:H10)

 

[Tetra201]

Try

=SUM(--B2:B3)

 

[Welsh Mark3]

Try

=SUM(--B2:B3)

Would this also work for this type of formula ?
=SUBTOTAL(9,I10:I700)

 

[Tetra201]

No, this approach does not work for SUBTOTAL.