get time between two rows, rows are not continuous.

[FuNeS13]

I have a spreadsheet that logs the start and finish of a task... I want to get the total time between the start and finish row, the thing is that the rows are not continuous, column A/B and F would be my triggers I guess as column A/B are the employee ID and Column F is the "Start/Finish" legend... the thing is that I have multiple employees filling this...

So lets say that I start my task as 07:01 AM by the time I finish, on 07:31 AM, n number of employees have also started tasks themselves... I have to get the total time for each task, for each employee... The trick is, the total time should be added to the "start" row...

Does this make any sense?

ID	Employee ID	Name	Area	WC	Type	Hour	Date	Time
5132	1587	FuNeS13	1	4602	Start	07:01	10/07/2019	0:30:00
5131	1586	Other1	2	4602	Start	07:02	10/07/2019	0:07:00
5131	1586	Other1	2	4602	Finish	07:07	10/07/2019
5132	1587	FuNeS13	1	4602	Finish	07:31	10/07/2019
5132	1587	FuNeS13	1	4602	Start	07:50	10/07/2019	(this is blank because I haven't finish the task yet)

<tbody>
</tbody>

 

[Fluff]

How about

Book1
	A	B	C	D	E	F	G	H	I
1	ID	Employee ID	Name	Area	WC	Type	Hour	Date	Time
2	5132	1587	FuNeS13	1	4602	Start	07:01	10/07/2019	00:30:00
3	5131	1586	Other1	2	4602	Start	07:02	10/07/2019	00:05:00
4	5131	1586	Other1	2	4602	Finish	07:07	10/07/2019
5	5132	1587	FuNeS13	1	4602	Finish	07:31	10/07/2019
6	5132	1587	FuNeS13	1	4602	Start	07:50	10/07/2019
Summary

Cell Formulas
Range	Formula
I2	=IF(F2="start",IFERROR(INDEX($G2:$G$6,MATCH(A2&"|"&B2&"|Finish",INDEX($A2:$A$6&"|"&$B2:$B$6&"|"&$F2:$F$6,0),0))-G2,""),"")

 

[Peter_SSs]

Slight variation ..

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	ID	Employee ID	Name	Area	WC	Type	Hour	Date	Time
2	5132	1587	FuNeS13	1	4602	Start	7:01	7/10/2019	0:30:00
3	5131	1586	Other1	2	4602	Start	7:02	7/10/2019	0:05:00
4	5131	1586	Other1	2	4602	Finish	7:07	7/10/2019
5	5132	1587	FuNeS13	1	4602	Finish	7:31	7/10/2019
6	5132	1587	FuNeS13	1	4602	Start	7:50	7/10/2019
Task Time

BTW, Are tasks always finished on the same day they are started?

 

[FuNeS13]

Both answers are correct!!! Thank you both for your great help!!!

BTW, Are tasks always finished on the same day they are started?

^^^
Yes!

 

[Fluff]

Glad we could help & thanks for the feedback

 

[Peter_SSs]

Both answers are correct!!! Thank you both for your great help!!!

You're welcome.

Yes!

In that case, and *if* an employee always finishes one task before starting another, you could also use one of these shorter versions.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	ID	Employee ID	Name	Area	WC	Type	Hour	Date	Time
2	5132	1587	FuNeS13	1	4602	Start	7:01	7/10/2019	00:30:00	00:30:00
3	5131	1586	Other1	2	4602	Start	7:02	7/10/2019	00:05:00	00:05:00
4	5131	1586	Other1	2	4602	Finish	7:07	7/10/2019
5	5132	1587	FuNeS13	1	4602	Finish	7:31	7/10/2019
6	5132	1587	FuNeS13	1	4602	Start	7:50	7/10/2019
Task Time (2)