You can use Peek(), but Peek() can only address rows already read in, not rows that are located in following records.
You can change the sort order of your table to overcome this:
(html, codepage is 1252, embedded labels, table is @1);
If(Peek('Status id') = 4 and [Status id] = 4,interval(Peek('update_date_time')- update_date_time )) as test
order by id_pk desc;
DROP TABLE INPUT;