Subtract 2 different rows from 2 different columns

MK9885 — Sat, 16 Nov 2024 19:35:24 GMT

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?

Thanks.

Re: Subtract 2 different rows from 2 different columns

MK9885 — Mon, 25 Nov 2019 21:50:28 GMT

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])