I am a swim coach and I am trying to create a table in which i can record times for swimmer for each length of the pool that they swim.  I then want to subtract the times between two lengths to get a split time for each lane.   I need to have mm:ss.00.    I have figured this out for anything less than 1 minute.  Once I need to enter minutes my formulas fail.  I am using a time format of mm:ss.000.  If I enter 0:32.7 in one cell and 0:16.20 in a second cell then subtract them I get the correct answer of 16.5 in a new cell that is formated as a number.

​I am a swim coach and I am trying to create a table in which i can record times for swimmer for each length of the pool that they swim.  I then want to subtract the times between two lengths to get a split time for each lane.   I need to have mm:ss.00.    I have figured this out for anything less than 1 minute.  Once I need to enter minutes my formulas fail.  I am using a time format of mm:ss.000.  If I enter 0:32.7 in one cell and 0:16.20 in a second cell then subtract them I get the correct answer of 16.5 in a new cell that is formated as a number.  Read More

​