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:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Status[/TD]
[TD]Shift[/TD]
[TD]Date[/TD]
[TD]Hour[/TD]
[TD]Min[/TD]
[TD]Sec[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]C/Out[/TD]
[TD]S2[/TD]
[TD]23/08/2019[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]C/In[/TD]
[TD]S1[/TD]
[TD]23/08/2019[/TD]
[TD]10[/TD]
[TD]42[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]C/Out[/TD]
[TD]SC[/TD]
[TD]23/08/2019[/TD]
[TD]23[/TD]
[TD]59[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]C/In[/TD]
[TD]S1[/TD]
[TD]22/08/2019[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]23[/TD]
[/TR]
</tbody>[/TABLE]

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:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]C/In[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Name[/TD]
[TD]Shift[/TD]
[TD]Date[/TD]
[TD]Hour[/TD]
[TD]Min[/TD]
[TD]Sec[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]= Find name occurences with "C/In" : Bob[/TD]
[TD]Retrieve corresponding shift S1[/TD]
[TD]= Find the 1st date with Clock in :
23/08/2019[/TD]
[TD]10[/TD]
[TD]42[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jim[/TD]
[TD]S1[/TD]
[TD]22/08/2019[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]23[/TD]
[/TR]
</tbody>[/TABLE]
..

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