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
Originally posted by roseth
Thanks for the Excel tips. Rob, I did as you said and created the custom formatting, which was just what I needed to do. (No point in doing it if you can't get down to hundredths, IMHO.) I actually keep an Excel spreadsheet with all of my times from every meet, so I just added a little split calculator page to the file. Now I can just plug in the times and be done with it. I think I will also create a yard/meters conversion formula as well.
Why bother with a calculator, guys?Say, the time is 1:05.48 and the split time is 32.23, ok, well 1:05.48 is 65.48 sec, just take that and substract 32.23 ignoring the point, like 6548 - 3223, then just put that point back there down to hundreds and there you go.I mean how much easier can it get that to just make that substraction.Well, you can use a calculator for that, too if you need it, just don't have that point scare you.
JUST SIMPLE MATH...
Originally posted by roseth
Thanks for the Excel tips. Rob, I did as you said and created the custom formatting, which was just what I needed to do. (No point in doing it if you can't get down to hundredths, IMHO.) I actually keep an Excel spreadsheet with all of my times from every meet, so I just added a little split calculator page to the file. Now I can just plug in the times and be done with it. I think I will also create a yard/meters conversion formula as well.
Why bother with a calculator, guys?Say, the time is 1:05.48 and the split time is 32.23, ok, well 1:05.48 is 65.48 sec, just take that and substract 32.23 ignoring the point, like 6548 - 3223, then just put that point back there down to hundreds and there you go.I mean how much easier can it get that to just make that substraction.Well, you can use a calculator for that, too if you need it, just don't have that point scare you.
JUST SIMPLE MATH...
