Looping Thru Records and Applying a Specific Logic

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!

Developer

Date Time

Best Practices

Accepted answers

All comments

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.

TaskTimeSampleFile.xlsx

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!

TaskTimeSampleFile.xlsx

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.

Looping Thru Records.yxzp

Qiu

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

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

0918-RonGatmaitan.yxmd

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!

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.

TaskTimeSampleFile.xlsx

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335