$$Excel-Macros$$ Find the second highest no.

Hi,, How to fnd the second highest no. in a grop of 10 No. using formulae. For eg. 12 3 45 1 18 90 15 76 99 9 the result should be 90. Can any1 hlp out with this? --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: How to convert number into hrs & min.

Use the Formula =INT(A4/60)&"Hr"&" "&(((A4/60)-INT(A4/60))*60)&"min" replace A4 by the cell refrence in your sheet. It can be modified further if you need, just drop me a mail Thanks n Regards Gaurav Banerjee 2009/8/9 Prasad Gadgil > *Dear Al