Hello everyone,
Thanks again for your help so far.
I have a new problem below :
I have a big data table like this:
<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:
<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
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