Difference in Lap times

[CHansford]

Folks,

I am struggling to calculate the difference in times (mm:ss.fff) between Lap times.  I want to be able to do any number of things like calculate the difference between the best lap_time and lap_time on each row for each position, car and driver in each race and ultimately overall for the race meeting.

I also need to be able to  calculate the total lap_times for each car and driver and rank those as well

I've included a set of sample data for ease of understanding.

Any help or assistance gratefully received. 

[tresesco]

Could you explain the expected output for the sample data provided?

[CHansford]

The intended output is in table format with all the relevant dimensions and measures being shown

[dplr-rn]

Maybe i am not getting the bigger picture/problem but

Did you try the TOTAL qualifier?
e.g. difference between lap time and fastest of the driver
=Interval(Only(LAP_TIME)-Min(TOTAL<Driver>LAP_TIME),'s.f')