Looping Thru Records and Applying a Specific Logic

[RonGatmaitan]

Hi,

I need to be able to compute, and eventually sum up, tasks done by employees. This being the case, I am looking to loop thru the records, apply the logic, and then compute.

The table is in this format.

Do note that certain tasks are still open which should be disregarded.

Thank you very much!

[Felipe_Ribeir0]

@RonGatmaitan ok, good luck with that :)

If you could accept the answer as a solution, i would be really grateful!

[RonGatmaitan]

Hi, @Luke_C, @Qiul, @Felipe_Ribeir0, 

Sorry, I missed a few thigs out.

1. Users may share a task.

2. Start and Ends without tasks in between are disregarded.

@Qiu, this is "almost" like what we did in Excel. Will this work if I used the Record ID, WITH the Row Number? First I filter those Starts and Ends, check the next and previous rows (as you did), AND check Record Id, if it's Record Id plus (or minus) one, to check if there are records in between.

@Felipe_Ribeir0, I would love to, but I need a bit more help on the requirements that I revised, please.