Subtract 2 different rows from 2 different columns

[MK9885]

Hi,

I've a requirement to create a new column based on subtracting 2 date columns

In above image, I'd like to get Turn around time by doing 10:30 - 10-45 and then 12:17 - 12:44

To create a new column with this...

Tried peek, above rangesum but doesn't seem to work.

Can anyone please tell me how to get TAT from previous time to current time in next row?

@sunny_talwar 

Thanks.

[MK9885 · Accepted solution]

Maybe I found the solution...

Divided into 3 exp. not ideal but works

Exp1: above(Total (Column2))-(Column2)

Exp:2: below(Total (Column1))-(Column1)

Final Exp: below(Total ([Exp1]))-([Exp2])