[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]

"Kashyap" wrote:
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 -----

"Kashyap" wrote in message
...
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?

[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.

"Kashyap" wrote:

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?

[Justin Case]

On Jun 11, 1:06*pm, Kashyap wrote:
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