Travel time between two appointments

[darren_dixon]

Hi

I am trying to calculate the time between the End Time of the first appointment and the Start Time of the second appointment.

All columns are fields except time taken which is an expression of: sum(End Time-Start Time)

Hope you can help.

Thanks,

Darren

[Gysbert_Wassenaar]

If the start times are ordered you can use [Start Time] - above([End Time]). The caveat is that this will simply pick the End Time of the row above. It does not take into account date changes or changes of Operative. It may be better addressed in the load script using the previous or peek function. It's easier to order the data and make sure that the travel time isn't calculated over the day changes or other changes of operative.

[darren_dixon]

Hi Gysbert,

Unfortunately this has not worked. The dates and start times aren't in any order and a sort is required on the Straight table to put them in order