Duh - I was doing one second not 10.

What (if anything)is wrong with my solution?
--
Wag more, bark less


"Rick Rothstein (MVP - VB)" wrote:

It is approximately 10 seconds less than 18 minutes and is subtracted from
the runners time so that the interval calculations can be made.

Rick


"Brad" wrote in message
...
Rick, what is 17.834 for?
--
Wag more, bark less


"Rick Rothstein (MVP - VB)" wrote:

Well, I have been holding on to this solution waiting for you to come
back
to me with an answer to my question... but since you haven't, I'll give
you
the "generalized" answer and you will have to substitute actual function
calls to replace the indicated values shown in angle brackets. This
formula
should calculate the "run score" (assuming you use "F" for female in
M8)...

=100-MAX(0,INT((<minutes+<seconds/60-17.834-3*(M8="F"))*6))

Rick



"Rick Rothstein (MVP - VB)" wrote
in
message ...
How are you entering your times... without colons? You do realize you
can't do simple subtraction on numbers entered that way and get correct
time calculations, right? Anyway, let me know what your time entries
actually are so I can either use them as entered (with colons) or
construct the appropriate corrections for them (with no colons and
assuming the digits represent MMSS).

Rick



"LoveExcelButFrustrated"
m wrote in message
...
Ok, so the conditions are this:

Males 26 and under have a run time of 18 minutes or less for a perfect
100
points. For every 10 seconds after that you subtract 1 point (so that
a
run
time of 18:01 - 18:10 = 99 points and a run time of 23:00 = 70 points)
Anything 28:01 and over is failing.

Males 27 to 39 have same perfect score but 29:01 and over is failing.

Males 40 - 45 have until 30:01 to pass.

Males 46 and over have until 33:01 to pass.

That's one. The other conditions a

Females 26 and under run a 21:00 or faster for 100 points. Same
subtraction
rate for points. 31:01 is failing point.

Females 27 - 39 have till 32:01 and females 40 - 45 have until 33:01
to
pass.

Females 46 and over have until 36:01.

I have the beginning I think. Here is what I have so far that I could
figure
out:

L8 is my Age block, M8 is my Gender block, and Y8 is my run time
block.
AA
is the run score block.

=(--(L8<27)*(M8="M"))*IF(Y8<=1800,100

I hope the beginning I have can help someone to help me lol. Thanks in
advance to anyone who can help this jumble out.