standings

[Kashyap]

Jean 06:52
Jackson 05:12
UmaU 00:00
Peter 05:36
Joseph 02:48

in the above table how to find out the standings of each? that is 1st or nd
or 3rd and so on?

 

[JoeU2004]

how to find out the standings of each? that is 1st or nd
or 3rd and so on?

Depending on which you consider 1st -- lowest or highest -- try one of the
following in B1 and copy down:

=rank(B1,$B$1:$B$5)

=rank(B1,$B$1:$B$5,1)


----- original message -----

 

[Sean Timmons]

use RANK()

=RANK(B2,B2:B6,1)

Depending on which order you want the rank to go, may want to use 0 instead
of 1.

 

[Justin Case]

Jean           06:52
 Jackson        05:12
 UmaU          00:00
 Peter          05:36
 Joseph         02:48

in the above table how to find out  the standings of each? that is 1st or nd
or 3rd and so on?

I'm assuming the numbers represent a timing situation, not actual
times of day. Either turn the numbers into a decimal value (like
"6.52") using

=VALUE(LEFT(D4,2))+(VALUE(RIGHT(D4,2))*0.01)

or if the number before the colon represents hours or minutes then

=VALUE(LEFT(D4,2))*60+(VALUE(RIGHT(D4,2)))

which will return an integer of the number of seconds or minutes.

Then use RANK as indicated above.

Regards,
Justin