Retrieve correct data in a table with formulas

[Arkine]

Hello everyone,

Thanks again for your help so far.
I have a new problem below :

I have a big data table like this:

Name	Status	Shift	Date	Hour	Min	Sec
Bob	C/Out	S2	23/08/2019	2	4	8
Bob	C/In	S1	23/08/2019	10	42	14
Bob	C/Out	SC	23/08/2019	23	59	26
Jim	C/In	S1	22/08/2019	9	9	23

<tbody>
</tbody>

So Bob clocked out the 23/08/2019 at 02:04 AM and clocked in again at 10:42AM, and so on.

I want to retrieve from this table values sorted by C/In, C/Out, Out for Break, Back from Break. Example with clock in:

	A	B
1	C/In
2	Name	Shift	Date	Hour	Min	Sec
3	= Find name occurences with "C/In" : Bob	Retrieve corresponding shift S1	= Find the 1st date with Clock in : 23/08/2019	10	42	14
	Jim	S1	22/08/2019	9	9	23

<tbody>
</tbody>

..

So basically i'm looking for a formula that retrieves all the values linked to C/In and that can be incremented.

Thanks for your help and please do tell me if i'm not clear enough.

Arkine

 

[Arkine]

Anyone got any clues?

 

[Arkine]

Up