Excel formula to convert number to both feet and inches

Question

I have a spreadsheet (excel 2010) where in column A I have a metric value (2413mm) and in column B I need a formula that will convert 2413mm to show the feet/inches in the following format (7' 11")

I can do this if I use 3 or 4 columns to first convert the 2413 to 7.9', then extract the feet and inches into two separate columns and finally concatenate the separate feet and inches into a final cell.

I'd really like to be able to do all this within one cell.

Answer 1

I notice that Gary's Student's answer will give you decimals in the inches - if you want the answer to the nearest inch try this version

=INT(ROUND(A1*0.03937,0)/12)&"' "&MOD(ROUND(A1*0.03937,0),12)&""""