excelexcel-formulaexcel-2010

Excel formula to convert number to both feet and inches

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.

Solution

  • 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)&""""