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?
Parents
Former Member
Excel 2000 (and I assume other versions) handles this directly with no "setup" at all if you can do without decimal places. Simply type in 2:43 in one cell, 1:20 in another and a standard subtraction formula in a third and you get a properly formatted answer. If you decimal places you can go into the cell formatting and create whatever format you want want in the way of min, sec, and decimal places.
Excel 2000 (and I assume other versions) handles this directly with no "setup" at all if you can do without decimal places. Simply type in 2:43 in one cell, 1:20 in another and a standard subtraction formula in a third and you get a properly formatted answer. If you decimal places you can go into the cell formatting and create whatever format you want want in the way of min, sec, and decimal places.
