I am a draftsman working with steel. I am developing a spreadsheet which
calculates the steel I use. The problem is in converting decimal ft. into
normal ft & inches.

example: Convert 10.4167 into 10'-5"

I tried the CONVERT function but to no avail.

Pls help.

And Thanks, I love the site!

Ed McClelland