Calculating a duration from repeated data values

[RogerA]

Hi, i am trying to use the data I have to report by "Trip ref" in my sample flow (attached).  Looking at trip "2367" in my data i would like to be able to report:

Total crew hours on the trip = 20 hours (this is done)

Overall trip duration  = 2.5 hours

Because i have multiple rows showing the overall trip duration, i only want to report this once against the trip ref.

Any ideas?

[MarqueeCrew · Accepted solution]

@RogerA,

One way to solve this is:  "First"

Cheers,

Mark

[RogerA]

thank you