Convert Decimal to Feet and Inches

R

RyanH

Is there a magic function that would format a decimal number to feet and
inches? For example,

MAGICFUNCTION(98.8125 inches) = 8'-2 13/16"
or
MAGICFUNCTION(8.234375 feet) = 8'-2 13/16"
 
G

Gary''s Student

We can come close. For example 7.83333 feet when formatted as:
#?" ft "?/12
displays:
7 ft 10/12
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top