Clump rows that are within 10 mins diff

Help
1

Hi, I am not sure how to phrase the question correctly. So let me try.

I have this excel.
I need users that have 5 failed and 1 success within 10 minutes.

image
image1672×1118 88 KB

What I am trying to say is, if it’s like this:

image
image1758×292 27.8 KB

Any suggestions on how can I clump the rows within 10 min difference?

Thank you xoxo

2

Try sort Datatable activity. First sort with status. And then sort with time.

3

Hi, how can I sort by time?
I am aware if I use the code below, I can get minutes difference.
But how can I compare when I can’t get the row above’s value?

(DateTime.ParseExact(“12/30/1899 18:00:00”, “MM/dd/yyyy HH:mm:ss”, System.Globalization.CultureInfo.InvariantCulture)-DateTime.ParseExact(“12/30/1899 08:30:00”, “MM/dd/yyyy HH:mm:ss”, System.Globalization.CultureInfo.InvariantCulture)).TotalMinutes.TOSTRING()