For the most super-easy way to enter your times in excel, just type the hatch mark (') before you type in the time. That signifies to excel that the box is a text-format box and whatever you type will show up exactly as you type it. Of course, since your time is now 'seen' by excel as text rather than numbers, it's not much use if you want to do anything with the data (plot or whatnot).
Muppet, I used to do my spreadsheets exactly like yours... lots of multiplying, subtracting, then putting it all back to together in multiple hidden columns. I refer to it as the 'brute force method'. I kinda like brute force and still use it to doublecheck when I come up with a slightly more elegant solution, but seriously, if you ever have to totally revamp your sheets try Chris Stevenson's method. It saves a lot of time and misery (and typing)!
I never thought of tracking my season bests over multiple seasons. Hmmm... that sounds pretty cool! Most of my excel effort goes into my training log which tracks yardage and workout time for swimming, weights, and PT exercises. I started tracking my workouts this way when I did tri's because I could not keep the three sports balanced without a pictoral representation. Now that I no longer do tri's, I converted the biking and running section to weights and PT. The dates are conditional formatted for intensity level and everything rolls up to month snapshots and a rolling season total. It's very helpful in tracking training habits (and taper!!!) from season to season.
For the most super-easy way to enter your times in excel, just type the hatch mark (') before you type in the time. That signifies to excel that the box is a text-format box and whatever you type will show up exactly as you type it. Of course, since your time is now 'seen' by excel as text rather than numbers, it's not much use if you want to do anything with the data (plot or whatnot).
Muppet, I used to do my spreadsheets exactly like yours... lots of multiplying, subtracting, then putting it all back to together in multiple hidden columns. I refer to it as the 'brute force method'. I kinda like brute force and still use it to doublecheck when I come up with a slightly more elegant solution, but seriously, if you ever have to totally revamp your sheets try Chris Stevenson's method. It saves a lot of time and misery (and typing)!
I never thought of tracking my season bests over multiple seasons. Hmmm... that sounds pretty cool! Most of my excel effort goes into my training log which tracks yardage and workout time for swimming, weights, and PT exercises. I started tracking my workouts this way when I did tri's because I could not keep the three sports balanced without a pictoral representation. Now that I no longer do tri's, I converted the biking and running section to weights and PT. The dates are conditional formatted for intensity level and everything rolls up to month snapshots and a rolling season total. It's very helpful in tracking training habits (and taper!!!) from season to season.
