Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time - 2 things: Average mm:ss.00, Negitive Times
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
average of times | Excel Discussion (Misc queries) | |||
Average of times where text may be in range | Excel Worksheet Functions | |||
How do I add a list of times to get an average time? | Excel Discussion (Misc queries) | |||
Formula to average certain times | Excel Discussion (Misc queries) | |||
Formula to Average times...again | Excel Discussion (Misc queries) |