Hello JE,

The formula works fine. Thank you very much indeed.
Nevertheless it remains a dark world for me. Cannot understand why it is
like it is.Never mind.

68magnolia71.



"JE McGimpsey" wrote:

If I understand you correctly:

C1: =SUMIF($A$1:$A1,A1,$B$1:$B1)

Format as a time, and copy down as far as necessary.



In article ,
68magnolia71 wrote:

Hello Julie,

For example: I did two batches of product "A" thus I sum the time spent =
5:15 + 6:15 total = 11:30 hours. Then I did 1 bach of product B time spent =
7:15 hours. Then I did 3 batches of product C, time spent: 8:15 + 9:15 4:15,
total time = 21:45 hours.

So what I meant is that each time the name of the product changes I will
have to restart the spent time so that I can calculate the capacity of the
workshop: so many tons in so many hours.
I might have empty rows between the operations. For example the first batch
of product A could be on row 1, the next one on row 10, with intermediate
steps for batch 1 in the rows 2 through 9 but no calculations.

Hopefully this will help you to built a formula.
Thank you anyway.