Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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])
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])