Turn around Time

[#1]

Hi All,

I am facing an issue here, I have the following set of data which I have attached below. All I need to find is the time interval between the different S_Status Field for each T_Name:

[tresesco]

Try to create an additional column in the dummy set to tell expected output.

[#3]

I created a new field named "Time_2" and used the following query in Text Object:

=Interval(if(S_Status='F',Time) - if(S_Status='D',RT_Time_Field_2),'hh:mm:ss')

This did not work.

[tresesco]

In your attached xls file above, add one more column stating your expected output and re-attach here.

[#5]

Please find the new excel sheet with the expected o/p.