Creating a Min-Max Time Calculation based on Transaction IDs

Good morning everyone,

​

I'm needing to calculate total time of a transaction. My report currently gives me the time it takes to complete individual actions in an overall transaction. Each action in a set transaction has the same transaction ID. I'm needing to take the minimum time (start time) in each transaction and the max time (end time) and calculate an overall elapsed time so I can account for time between actions.

​

I also have it broken down into the number of seconds or minutes individual actions took, but creating a summation off of that would exclude time between actions.

​

So I will need to see how long it took the 3 actions in 235529 from lowest time to highest time, then the 2 actions in 235530, etc. Some of these transactions can have upwards of 30 individual actions.

I would just be placing the resulting expression in a column at the end of the query.

https://i.redd.it/tx0db8xzuc231.png