Hi,
1. I'm a Track coach and would like to keep track of over 100 runners'
times (ss.00 and mm:ss.00) throughout the season. I would like to be able to
calculate team averages as well as track individual's progress.
Meet 1 Meet 2 Net Difference (+ -)
runner 1
runner 2
runner 3
team averages:
I've read many of the posts, and none really solves my problems. Is there a
way to pre-format cells so I can just enter mm:ss.00 (or ss.00) without
having to preform complicated formulas and chant evocations to the cybergods?
Nothing in Custom seemed to work, and using 00:mm:ss.00 will not allow for
accurate averaging.
2. ALSO, I need to be able to show negitive times when runners do worse.
Excell doesn't like negitive times and only shows ######. Absolute Value will
produce the number, but is mis-leading, and again affects the average. Other
ideas?
Thank you!
Steve