sum

[xaritona89]

Please help me

Damage ID	Status	Tab	product	time	Cable time Delay (Damage ID)	Cable time Delay (Damage ID) Delayed firm1 and firm2 time sum
80640	Cable	Cable - new application	dsl	36939:51:15	??(One and the same: ID 80640 )	??
80640	Cable	Delayed firm2	dsl	3991:19:15	??(One and the same: ID 80640 )	??
80640	Cable	Delayed firm1	dsl	43:45:48	??(One and the same: ID 80640 )	??
80640	Cable	Cable - new application	dsl	661:21:50	??(One and the same: ID 80640 )	??
80640	Cable	Cable - new application	dsl	43:45:48	??(One and the same: ID 80640 )	??
80640	test	test1	dsl	1:20:42	??(One and the same: ID 80640 )	??
80640	test	test1	dsl	5848:58:32	??(One and the same: ID 80640 )	??
80640	end	test1	dsl	0:00:00	??(One and the same: ID 80640 )	??
80663	Cable	Cable - new application	dsl	35998:53:51	??(One and the same: ID 80663 )	??
80663	Cable	Delayed firm1	dsl	4932:16:40	??(One and the same: ID 80663 )	??
80663	Cable	Cable - new application	dsl	827:35:31	??(One and the same: ID 80663 )	??
80663	Cable	Cable - new application	dsl	45:38:44	??(One and the same: ID 80663 )	??
80663	test	test1	dsl	0:15:23	??(One and the same: ID 80663 )	??
80663	test	test1	dsl	3458:57:16	??(One and the same: ID 80663 )	??
80663	test	test1	dsl	410:30:04	??(One and the same: ID 80663 )	??
80663	test	test1	dsl	23:21:28	??(One and the same: ID 80663 )	??
80663	test	test1	dsl	1:01:29	??(One and the same: ID 80663 )	??
80663	test	test1	dsl	25:45:57	??(One and the same: ID 80663 )	??
80663	Cable	Cable - new application	dsl	18:35:18	??(One and the same: ID 80663 )	??
80663	Cable	Cable - new application	dsl	28:23:18	??(One and the same: ID 80663 )	??
80663	Cable	Cable - new application	dsl	2:20:04	??(One and the same: ID 80663 )	??
80663	Cable	Cable - new application	dsl	1:24:54	??(One and the same: ID 80663 )	??
80663	test	test1	dsl	2:26:41	??(One and the same: ID 80663 )	??
80663	test	test1	dsl	1960:23:02	??(One and the same: ID 80663 )	??
80663	end	test1	dsl	0:00:00	??(One and the same: ID 80663 )	??

<tbody>
</tbody>

F
= ??(One and the same: ID 80640 ) =41680:03:56
=??(One and the same: ID 80663 )=41855:08:20

G
??(ID 80640) =4035:05:03

??(ID 80663) = 4932:16:40 <tbody> </tbody>

<tbody>
</tbody>

 

[xaritona89]

 

[Joe4]

If you are just looking to sum specific IDs, take a look at the SUMIF function.
See here for details and examples: https://www.techonthenet.com/excel/formulas/sumif.php

 

[xaritona89]

Thank you, but
Only this formula can not be counted

 

[Joe4]

Only this formula can not be counted

I don't know what you mean by this. Please explain.

It is important to not just post screen images, but explain in detail exactly what the problem is.

 

[shg]

If you widen column E and remove the centering, you'll see

	E​
1​	----------time----------
2​	36939:51:15
3​	3991:19:15​
4​	43:45:48​
5​	661:21:50​
6​	43:45:48​
7​	1:20:42​
8​	5848:58:32​
9​	0:00:00​
10​	35998:53:51
11​	4932:16:40​
12​	827:35:31​
13​	45:38:44​
14​	0:15:23​
15​	3458:57:16​
16​	410:30:04​
17​	23:21:28​
18​	1:01:29​
19​	25:45:57​
20​	18:35:18​
21​	28:23:18​
22​	2:20:04​
23​	1:24:54​
24​	2:26:41​
25​	16:23:02​
26​	0:00:00​

That left alignment for those two entries is telling you that they are text (which means the SUM function will ignore them), and that's because Excel won't recognize a time value with hours > 9999.

You could use a formula:

=LEFT(E2, FIND(":", E2) - 1)/24 + (0 & RIGHT(E2, 6))

and then paste that result over the original value.

 

[xaritona89]

Excuse me, I can not explain it well,
I want time to sum,

E column: Damage ID: "80640", Status: "Cable" :::: time: sum
F Column: Damage ID: "80640", Status: "Cable", Tab: "Delayed firm1, and Delayed firm2" :::: time: sum

Damage ID	Status	Tab	time	Cable time Delay (Damage ID)	Cable time Delay (Damage ID) Delayed firm1 and firm2 time sum
80640	Cable	Cable - new application	1539.16059	Damage ID: 80640, status: cable: sum: time	Damage ID: 80640, status: cable: tab: "Delayed firm1" and "Delayed firm1" sum: time
80640	Cable	Delayed firm2	166.3050347
80640	Cable	Delayed firm1	1.823472222
80640	Cable	Cable - new application	27.5568287
80640	Cable	Cable - new application	1.823472222
80640	test	test1	0.056041667
80640	test	test1	243.7073148
80640	end	test1	0

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Please move this table to Excel,


I hope well to explain

 

[Joe4]

I want time to sum,

So, why can't you use SUMIF then?

Did you see shg's important note above?

 

[shg]

	A​	B​	C​	D​	E​	F​	G​
1​	Damage ID​	Status​	Tab​	product​	------time------​	Total by ID​
2​	80640​	Cable	Cable - new application	dsl	36939:51:15​	47530:23:10​	F2 and down: =IF(A2 = A1, "", SUMIF($A$2:$A$26, A2, $E$2:$E$26))
3​	80640​	Cable	Delayed firm2	dsl	3991:19:15​
4​	80640​	Cable	Delayed firm1	dsl	43:45:48​
5​	80640​	Cable	Cable - new application	dsl	661:21:50​
6​	80640​	Cable	Cable - new application	dsl	43:45:48​
7​	80640​	test	test1	dsl	1:20:42​
8​	80640​	test	test1	dsl	5848:58:32​
9​	80640​	end	test1	dsl	0:00:00​
10​	80663​	Cable	Cable - new application	dsl	35998:53:51​	47737:49:40​
11​	80663​	Cable	Delayed firm1	dsl	4932:16:40​
12​	80663​	Cable	Cable - new application	dsl	827:35:31​
13​	80663​	Cable	Cable - new application	dsl	45:38:44​
14​	80663​	test	test1	dsl	0:15:23​
15​	80663​	test	test1	dsl	3458:57:16​
16​	80663​	test	test1	dsl	410:30:04​
17​	80663​	test	test1	dsl	23:21:28​
18​	80663​	test	test1	dsl	1:01:29​
19​	80663​	test	test1	dsl	25:45:57​
20​	80663​	Cable	Cable - new application	dsl	18:35:18​
21​	80663​	Cable	Cable - new application	dsl	28:23:18​
22​	80663​	Cable	Cable - new application	dsl	2:20:04​
23​	80663​	Cable	Cable - new application	dsl	1:24:54​
24​	80663​	test	test1	dsl	2:26:41​
25​	80663​	test	test1	dsl	1960:23:02​
26​	80663​	end	test1	dsl	0:00:00​

 

[xaritona89]

no "

Total by ID",

​

Example

​

A: id:​

80640
B: status: cable

total "cable" time sum, whith ID 80640
no sum b: "test".

​

A​	B​	C​	D​	E​	F​	G​
1​	Damage ID​	Status​	Tab​	product​	------time------​	Total by ID​
2​	80640​	Cable	Cable - new application	dsl	36939:51:15​	47530:23:10​	F2 and down: =IF(A2 = A1, "", SUMIF($A$2:$A$26, A2, $E$2:$E$26))
3​	80640​	Cable	Delayed firm2	dsl	3991:19:15​
4​	80640​	Cable	Delayed firm1	dsl	43:45:48​
5​	80640​	Cable	Cable - new application	dsl	661:21:50​
6​	80640​	Cable	Cable - new application	dsl	43:45:48​
7​	80640​	test	test1	dsl	1:20:42​
8​	80640​	test	test1	dsl	5848:58:32​
9​	80640​	end	test1	dsl	0:00:00​
10​	80663​	Cable	Cable - new application	dsl	35998:53:51​	47737:49:40​
11​	80663​	Cable	Delayed firm1	dsl	4932:16:40​
12​	80663​	Cable	Cable - new application	dsl	827:35:31​
13​	80663​	Cable	Cable - new application	dsl	45:38:44​
14​	80663​	test	test1	dsl	0:15:23​

<tbody>
</tbody>

​

thanks