Time Calculation

[#1]

Hi,

During a data load I need to create a turnaround time from a dataset.  In the example below, there is a distinct session id for a particular date.  Within this session there are three units and by my calculation the average turnaround time for these three units is 49.5 mins.

Is it possible to create a field that calculates these turnaround times?

Many thanks for any help,

[sunny_talwar · Accepted solution]

May be like this

LOAD *,

          If(Session = Previous(Session), RangeSum([Time Started], -Previous([Time Finished]))) as [Turnaround Time]

Resident .....

Order By Session, [Time Started];

[#3]

thank you - works perfectly.