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