Calculate error times based on recurring text string

[PSD]

Hi all,

I am looking for an efficient way to calculate the error time from a sheet of data based on the name column (B).
When the value of a certain error is 1, the error is started and when the value is 0, the error is solved (column C).
There are a lot of different errors, which sometimes simultaneously are present (An earlier error is not solved yet, but the next error is already present).
Being inexperienced with Excel, this makes it difficult for me to extract the error times (time stamps in column D) without having to filter X amount of error names in order to successfully calculate the error times.

My question is, does anyone have a shout on an efficient line of code or macro which best handles what I wish to achieve?
(Office 365)

 

[StephenCrump]

Welcome to the Forum!

Do you mean something like this?

	A	B	C	D	E	F
1						Elapsed
2	Error Name 1	1	14 Sep 2021	10:20 AM		5:40
3	Error Name 2	1	14 Sep 2021	11:30 AM		20:30
4	Error Name 1	0	14 Sep 2021	4:00 PM
5	Error Name 3	1	15 Sep 2021	12:30 AM		6:40
6	Error Name 1	1	15 Sep 2021	4:00 AM		2:45
7	Error Name 1	0	15 Sep 2021	6:45 AM
8	Error Name 3	0	15 Sep 2021	7:10 AM
9	Error Name 2	0	15 Sep 2021	8:00 AM
10	Error Name 4	1	15 Sep 2021	9:00 AM		1:30
11	Error Name 1	1	15 Sep 2021	10:25 AM		Open
12	Error Name 4	0	15 Sep 2021	10:30 AM
Sheet2

Cell Formulas
Range	Formula
F2:F11	F2	=IF(B2=0,"",IFERROR(SUM(INDEX(FILTER(C3:D$12,(A3:A$12=A2)*(B3:B$12=0)),1,))-SUM(C2:D2),"Open"))

 

[PSD]

Hi Stephen,

Indeed this was what I meant, and your proposed solution worked!
Thank you for the help.

 

[StephenCrump]

That's great. I'm glad it works for you.