Looping through two columns to find the difference between current row and previous row

[Anonymous]

Hello All,

I have a requirement to find the duration between two dates for a particular set of data.

I need to find the delay between end time of one row to the start time of next row, data will be sorted on the basis of start time, that shows the rank field which I had created.

Solution for delay for category AA should be 18:19:00(end time of 4th row)-18:39:10(start time of 5th row) + 18:41:20(end time of 5th row)-18:47:46(start time of 5th row)+18:56:17(end time of 7th row)-18:59:20( start time of 7th row).Ideally, the end time of first job should be the start time of the second job, if it's not, we should find the delay.In case, end time of the first job is greater than the start time of the second, third or fourth row, the delay should be found between the max of end time between the 4 jobs and start time of the next job.

the logic has to be applicable for each category and subcategory.Ranking is done at job level based on start time of the job.I havent included jobs field here,but rank shows the number of jobs between each sub category.

Could you please e resolve this.