CODEWITHSUNDEEP
excel
Darren Goulden
Darren Goulden

Reputation: 5

Excel: Calculate duration hh:mm:ss based on a separate column

I have two columns with different data, I need to calculate the duration in hh:mm:ss based on the data in column A, (example below), at the moment I'm having to do this manually using filters, is there an easier way?

A   B
2   00:00:04
2   00:00:07
4   00:06:23
4   00:02:07
1   00:07:07
1   00:01:08

total of 2 would equal 00:00:11
total of 4 would equal 00:08:30
total of 2 would equal 00:08:15

Upvotes: 0

Views: 572

Answers (1)

David M
David M

Reputation: 72840

Try the SUMIF function:

=SUMIF(A2:A7, 2, B2:B7)

This sums the values in B2:B7 where the corresponding value in A2:A7 is equal to the middle parameter, 2.

Upvotes: 2

Related Questions