Saturday, November 25, 2017

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
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.


#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.