Hi @Dhanushka_A
you can do it in a single Multi-Row tool if you use the following formula, grouped by Location_id and customer_id
if isnull([row-1:timediff]) then
0
elseif [Row-1:TimeDiff]+datetimediff([DATE],[Row-1:DATE],"seconds")>=24*60*60 then
0
else
[Row-1:TimeDiff]+ datetimediff([DATE],[Row-1:DATE],"seconds")
endif
The first if handles the first record in every group. The next one checks if the previous time difference + the current time difference >= 24 hours and sets the time difference for the current row to 0. The else clause adds the previous difference to the current and stores that. If effectively creates a running total that resets to 0 if it goes above 24 hours. Then you discard all the records that have a non-zero difference
Dan
