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!

[Luke_C]

What are you summing, time? Can you share what the desired output looks like? Can you share the data instead of a screenshot

[RonGatmaitan]

Hi @Luke_C,

Yes, time. :)

Here's a sample file.

[Qiu]

@RonGatmaitan 
What will be the expected output?
Say in your sample data, For user A, complete Task count is 1 and also 1 for user B?

[RonGatmaitan]

Hi @Qiu.

Total time. So, 5 minutes for User A and 1 minute and 30 seconds for User B.

Do note that there will be multiple tasks so, there may be a Task 4, where User A will appear again.

[Qiu]

@RonGatmaitan 
Thank you for the clarfication.
If we calculate the time difference betwteen start and end for User A, it is inddeed 5 minutes.
but it is 2 minutes, rather than 1.5 minutes as you have said. 
Can you kindly explain the logic I am missing?
 and it would be greate if you can upload a data file since the picture is not so good to work with. 😁

[RonGatmaitan]

Hi @Qiu,

Sorry, it really is 2 minutes. Miscalculated on my part. 😁

I already uploaded the data for Luke, but here. 😊

Thank you!

[Felipe_Ribeir0]

@RonGatmaitan , i dont know if i understood well, but please see if it is it.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[Qiu]

@RonGatmaitan 
Thank you again and sorry about the attachment. Miss it.

I would give a different approach to use Multi-row tool.

[RonGatmaitan]

Hi @Felipe_Ribeir0

I think you did, fairly well. 😀

Let me apply this to actual data. The structure is a bit more complicated than this. I only simplified for easier understanding, but I think I can apply the same logic.

Thank you very much!