Formating cells to add in feet and inches

[Mark]

I want to put a size, say 4 feet 5 inches in one cell and multiply this by,
say, 2 ft 3 inches in another cell. How do I format the cells to show 4'5"
and then calculate?

Thanks,

Mark

 

[Bernard Liengme]

Visit www.cpearson.com where Chip has stuff on feet and inches
best wishes from the metric world