How could I script so that I get back the correct duration for each row?
I have a table consisting of timestamps (attached).They are categorized into T7 timestamps which could be any of T7/T7A/B/C/D…..H etc. and T8 timestamps which could be any of T8/T8A/B/C/D….H etc.I need to subtract the largest T7 value from the largest T8 value available for that row and I have made a column “T8-T7” to identify those values.How could I script so that I get back the correct duratio...