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?

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Employee ID[/TD]
[TD]Name[/TD]
[TD]Area[/TD]
[TD]WC[/TD]
[TD]Type[/TD]
[TD]Hour[/TD]
[TD]Date[/TD]
[TD]Time[/TD]
[/TR]
[TR]
[TD]5132[/TD]
[TD]1587[/TD]
[TD]FuNeS13[/TD]
[TD]1[/TD]
[TD]4602[/TD]
[TD]Start[/TD]
[TD]07:01[/TD]
[TD]10/07/2019[/TD]
[TD]0:30:00[/TD]
[/TR]
[TR]
[TD]5131[/TD]
[TD]1586[/TD]
[TD]Other1[/TD]
[TD]2[/TD]
[TD]4602[/TD]
[TD]Start[/TD]
[TD]07:02[/TD]
[TD]10/07/2019[/TD]
[TD]0:07:00[/TD]
[/TR]
[TR]
[TD]5131[/TD]
[TD]1586[/TD]
[TD]Other1[/TD]
[TD]2[/TD]
[TD]4602[/TD]
[TD]Finish[/TD]
[TD]07:07[/TD]
[TD]10/07/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5132[/TD]
[TD]1587[/TD]
[TD]FuNeS13[/TD]
[TD]1[/TD]
[TD]4602[/TD]
[TD]Finish[/TD]
[TD]07:31[/TD]
[TD]10/07/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5132[/TD]
[TD]1587[/TD]
[TD]FuNeS13[/TD]
[TD]1[/TD]
[TD]4602[/TD]
[TD]Start[/TD]
[TD]07:50[/TD]
[TD]10/07/2019[/TD]
[TD](this is blank because I haven't finish the task yet)[/TD]
[/TR]
</tbody>[/TABLE]

 

[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)