Sum in dd:hh:mm:ss

**shg** · 03-19-2019, 05:02 PM

Excel doesn't recognize those strings as numbers.

	A	B
1	1:17:41:24
2	0:01:39:00
3	1:19:20:24	A3: =TEXT(SUMPRODUCT(--LEFT(A1:A2, FIND(":", A1:A2) - 1)) + SUMPRODUCT(--MID(A1:A2, FIND(":", A1:A2) + 1, 8)), "d:hh:mm:ss")

That will only work to a total of 31 days.

**AngelJD25** · 03-19-2019, 05:23 PM

That worked! Thank you and greetings to the lone star state

**AngelJD25** · 03-19-2019, 05:30 PM

That worked! Could you help me for more than 31 days? I have hundreds of data, I'm sure it will add way more than 30 days. Thank you and greetings to the lone star state

**AngelJD25** · 03-19-2019, 05:32 PM

Originally Posted by shg

Excel doesn't recognize those strings as numbers.

	A	B
1	1:17:41:24
2	0:01:39:00
3	1:19:20:24	A3: =TEXT(SUMPRODUCT(--LEFT(A1:A2, FIND(":", A1:A2) - 1)) + SUMPRODUCT(--MID(A1:A2, FIND(":", A1:A2) + 1, 8)), "d:hh:mm:ss")

That will only work to a total of 31 days.

That worked! Could you help me for more than 31 days? I have hundreds of data, I'm sure it will add way more than 30 days. Thank you and greetings to the lone star state