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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time - 2 things: Average mm:ss.00, Negitive Times
You need to enter it as
hh:mm:ss.00 so if a time is 11 seconds 25 hundredths it should be entered as 00:00:11.25 then you can just use =AVERAGE(range) and use custom format ss.00 for the result If you need to be able to get negative times you can do toolsoptionscalculation and put a check mark next to 1904 date system. It will add 1462 days to all dates you might have but that can be subtracted to get the correct dates if necessary -- Regards, Peo Sjoblom "Steve" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time - 2 things: Average mm:ss.00, Negitive Times
You can probably save a little bit of typing and get away with typing in
0:11.25 -- David Biddulph "Peo Sjoblom" wrote in message ... You need to enter it as hh:mm:ss.00 so if a time is 11 seconds 25 hundredths it should be entered as 00:00:11.25 then you can just use =AVERAGE(range) and use custom format ss.00 for the result If you need to be able to get negative times you can do toolsoptionscalculation and put a check mark next to 1904 date system. It will add 1462 days to all dates you might have but that can be subtracted to get the correct dates if necessary -- Regards, Peo Sjoblom "Steve" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time - 2 things: Average mm:ss.00, Negitive Times
I am greatful for your time, thank you. I was hoping to not have to deal
with hh: (or h: as you suggested), but it looks like your solution is the only way. I found that [mm]:ss.00 keeps the minutes from being forced into hours and allows for accurate averaging. And thanks for the tip on the check by 1904 system to allow for negative times - that works. Thanks again, Steve "David Biddulph" wrote: You can probably save a little bit of typing and get away with typing in 0:11.25 -- David Biddulph "Peo Sjoblom" wrote in message ... You need to enter it as hh:mm:ss.00 so if a time is 11 seconds 25 hundredths it should be entered as 00:00:11.25 then you can just use =AVERAGE(range) and use custom format ss.00 for the result If you need to be able to get negative times you can do toolsoptionscalculation and put a check mark next to 1904 date system. It will add 1462 days to all dates you might have but that can be subtracted to get the correct dates if necessary -- Regards, Peo Sjoblom "Steve" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time - 2 things: Average mm:ss.00, Negitive Times
There is no difference using the [mm]:ss.00, it's just that it will be
displayed the correct way, the underlying value is still the same -- Regards, Peo Sjoblom "Steve" wrote in message ... I am greatful for your time, thank you. I was hoping to not have to deal with hh: (or h: as you suggested), but it looks like your solution is the only way. I found that [mm]:ss.00 keeps the minutes from being forced into hours and allows for accurate averaging. And thanks for the tip on the check by 1904 system to allow for negative times - that works. Thanks again, Steve "David Biddulph" wrote: You can probably save a little bit of typing and get away with typing in 0:11.25 -- David Biddulph "Peo Sjoblom" wrote in message ... You need to enter it as hh:mm:ss.00 so if a time is 11 seconds 25 hundredths it should be entered as 00:00:11.25 then you can just use =AVERAGE(range) and use custom format ss.00 for the result If you need to be able to get negative times you can do toolsoptionscalculation and put a check mark next to 1904 date system. It will add 1462 days to all dates you might have but that can be subtracted to get the correct dates if necessary -- Regards, Peo Sjoblom "Steve" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time - 2 things: Average mm:ss.00, Negitive Times
Yes, thank you.
"Peo Sjoblom" wrote: There is no difference using the [mm]:ss.00, it's just that it will be displayed the correct way, the underlying value is still the same -- Regards, Peo Sjoblom "Steve" wrote in message ... I am greatful for your time, thank you. I was hoping to not have to deal with hh: (or h: as you suggested), but it looks like your solution is the only way. I found that [mm]:ss.00 keeps the minutes from being forced into hours and allows for accurate averaging. And thanks for the tip on the check by 1904 system to allow for negative times - that works. Thanks again, Steve "David Biddulph" wrote: You can probably save a little bit of typing and get away with typing in 0:11.25 -- David Biddulph "Peo Sjoblom" wrote in message ... You need to enter it as hh:mm:ss.00 so if a time is 11 seconds 25 hundredths it should be entered as 00:00:11.25 then you can just use =AVERAGE(range) and use custom format ss.00 for the result If you need to be able to get negative times you can do toolsoptionscalculation and put a check mark next to 1904 date system. It will add 1462 days to all dates you might have but that can be subtracted to get the correct dates if necessary -- Regards, Peo Sjoblom "Steve" wrote in message ... 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 |
Reply |
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) |