Comparing 2 columns of time

  • Thread starter Thread starter TARogers
  • Start date Start date
T

TARogers

I am trying to compare 2 columns of time. Here is the formula I am
trying to use:

=IF(H2>(LOOKUP(Sheet3!A2,Minimums!A2:A35,Minimums!D2:D35)),
"Pass","Fail")

H2 is the run time (mm:ss), A2 is their age, A2:A35 and D2:D35 is ages
and max times.

Basically, I look at someone age, then take the time it took them to
run 3 miles and compare that time to a maximum standard time for the
same age.
Example: 22 year old male has 28 minutes to run 3 miles.

I want to have the cell tell me if the run time is greater than the max
allowed time.


Any help will this is greatly appreciated. Thanks.
 
It looks like you've got your "Pass" & "Fail" inverted (based on my
understanding of your logic). But other than that, your formula looks good.
Is there something amiss in the results?

Are your ages sorted (ascending) on the Minimums sheet?

/i.
 
immanuel,

Yes the result does not change once the time goes belong the ma
allowed time (i.e., the result says "Pass" for a 22:15 time, but still
says "Pass" for a 29:26 time). I tried changing the inequalities an
text result ("Pass" or "Fail"), but have not had any success. You
help is greatly appreciated.

Tod
 
Hi Todd,

Would you like to post a sample of your real data? It might help me help
you more efficiently.

/i.
 
Back
Top