Need assistance with creating a "datediff" type of formula.

I have timestamps in the {incilog} table, in different rows across the same column {incilog.timestamp} that I need to subtract from one another, but only if the {incilog.descript} equals "Time Received" from the row that has the {incilog.descript} equal "Entered Nature".

Logic is: If {incilog.descript} equals "Time Received" and {incilog.descript} equals "Entered Nature", then subtract {incilog.timestamp} from {inciog.timestamp} in the corresponding row.

Basically, I need to get how many seconds it took from "Time Received" to "Entered Nature".

NOTE: I CANNOT USE THE "transtype" COLUMN, as there are other unique descript that use this same transtype

THANK YOU FOR YOUR TIME AND ASSISTANCE!

EXAMPLE OF DATA

timestamp              inci_id       transtype   descript
8/22/2022 12:14:46 AM    2022264051    TR        Time Received
8/22/2022 12:17:00 AM    2022264051    ENT        Entered Nature

How are you grouping your data? Will "Entered Nature" always be the record right after the "Time Received" record or could there be other records between them?

-Dell

It is being grouped by the "inci_id" column.

Unfortunately Entered Nature will not always be right after Time Received (other records are between them).