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?
Take out your trusty calculator and convert all times to seconds, then subtract, e.g. 1:04.36 is 64.36 seconds. Isn't this simple enough? I'm sure Excel could be set up to do this. Maybe you could set up one coumn for minutes, then the next one for seconds and hundredths. So if column A is minutes and B is seconds just enter the formula A*60+B and make that column C. Then get your splits by subtracting, for example, C2 from C3 or whatever.
Take out your trusty calculator and convert all times to seconds, then subtract, e.g. 1:04.36 is 64.36 seconds. Isn't this simple enough? I'm sure Excel could be set up to do this. Maybe you could set up one coumn for minutes, then the next one for seconds and hundredths. So if column A is minutes and B is seconds just enter the formula A*60+B and make that column C. Then get your splits by subtracting, for example, C2 from C3 or whatever.
