yogi_Compute Row By Row Time Differences From Base Value In Cell B2 With Times In mm:ss.sss

Google Spreadsheet   Post  #2302

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-23-2017

question by: Rene Englehardt

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/pCK3x624BJI;context-place=forum/docs

Difference in times (e. g.) motorracing events

I'd like to know how to achieve the following difference in time through GSheets

I have a couple of values that are essentially the ending times of a person (as an example from a motorsport result). Those look like MM:SS.SSS (30:55.112). Important is to have it calculate the difference from the fastest to the other times.

Example:

#1 30:55.112

#2 30:55.180 (+0.068) 

#3 30:55.413 (+0.301)

#4 31:01.226 (+6.114)

I need the values in bold to be calculated through GSheets.