I'm wondering if anyone has a simple way of calculating subtractive split times. For example, if you swim 100 Free and your time is 1:04.36, and the results show your split time as 31.62, is there a simple way to calculate what your time was for the 2nd 50? I know that on the USMS site, you can look up some of your results, and often these include subtractive splits, but this site does not list all meets. Is there a website that has a "calculator" for this purpose? Or does anyone know a way of programming something like Excel to calculate these?
And a couple of Excel notes:
To get proper subtraction of times, always enter minutes, even if 0. So 31.62 should be entered as 0:31.62
If you want to display hundredths, you may need to change the cell format; Format Cells – Number tab – select Custom – Type: mm:ss.00
And a couple of Excel notes:
To get proper subtraction of times, always enter minutes, even if 0. So 31.62 should be entered as 0:31.62
If you want to display hundredths, you may need to change the cell format; Format Cells – Number tab – select Custom – Type: mm:ss.00
