Thread: formula to convert decimal feet to feet inch sixteenths

I would like to write a formula in excel, without using macros, to convert
decimal feet to feet-inch-sixteenths.

Can someone help me ?

Is this any good?

=TEXT(INT(D18)," 0 ""feet """)&INT(MOD(D18,1)*12)&"
"&TEXT(MOD(D18*12,1),"0/16")&" inches"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"tv" <tv@discussions.microsoft.com> wrote in message
news:519E2C11-5977-4479-A573-5C7470DBB769@microsoft.com...
> I would like to write a formula in excel, without using macros, to convert
> decimal feet to feet-inch-sixteenths.
>
> Can someone help me ?

"tv" <tv@discussions.microsoft.com> wrote in message
news:519E2C11-5977-4479-A573-5C7470DBB769@microsoft.com...
>I would like to write a formula in excel, without using macros, to convert
> decimal feet to feet-inch-sixteenths.
>
> Can someone help me ?

Are you able to write the formula on paper first?

Decimal value in A1, formula in B1:


=INT(A1) & " ft " & TEXT(MOD(A1,1)*12, "# ??/16") & "in"

A1=2.345 (ft)

B1=2 ft 4 2/16 in

HTH

"tv" wrote:


> I would like to write a formula in excel, without using macros, to convert
> decimal feet to feet-inch-sixteenths.
>
> Can someone help me ?

Whilst I concede that yours is much better than mine, it can still be
improved upon <vbg>

=INT(A1) & " ft " & TEXT(MOD(A1,1)*12, "# ??/16 ""in""")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Toppers" <Toppers@discussions.microsoft.com> wrote in message
news:94F33E54-AB05-4FA2-BDA2-A95800A648C5@microsoft.com...
> Decimal value in A1, formula in B1:
>
>
> =INT(A1) & " ft " & TEXT(MOD(A1,1)*12, "# ??/16") & "in"
>
> A1=2.345 (ft)
>
> B1=2 ft 4 2/16 in
>
> HTH
>
> "tv" wrote:
>
>
> > I would like to write a formula in excel, without using macros, to
convert
> > decimal feet to feet-inch-sixteenths.
> >
> > Can someone help me ?

Bob,
I'm flattered!

"Bob Phillips" wrote:

> Whilst I concede that yours is much better than mine, it can still be
> improved upon <vbg>
>
> =INT(A1) & " ft " & TEXT(MOD(A1,1)*12, "# ??/16 ""in""")
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Toppers" <Toppers@discussions.microsoft.com> wrote in message
> news:94F33E54-AB05-4FA2-BDA2-A95800A648C5@microsoft.com...
> > Decimal value in A1, formula in B1:
> >
> >
> > =INT(A1) & " ft " & TEXT(MOD(A1,1)*12, "# ??/16") & "in"
> >
> > A1=2.345 (ft)
> >
> > B1=2 ft 4 2/16 in
> >
> > HTH
> >
> > "tv" wrote:
> >
> >
> > > I would like to write a formula in excel, without using macros, to
> convert
> > > decimal feet to feet-inch-sixteenths.
> > >
> > > Can someone help me ?
>
>
>

Thamk you for this formula
however, i would like my result to read in the following format (ex: 4-6-8)

can you help me tune the formula

thanks

"Toppers" wrote:

> Decimal value in A1, formula in B1:
>
>
> =INT(A1) & " ft " & TEXT(MOD(A1,1)*12, "# ??/16") & "in"
>
> A1=2.345 (ft)
>
> B1=2 ft 4 2/16 in
>
> HTH
>
> "tv" wrote:
>
>
> > I would like to write a formula in excel, without using macros, to convert
> > decimal feet to feet-inch-sixteenths.
> >
> > Can someone help me ?

On Tue, 7 Mar 2006 13:27:26 -0800, tv <tv@discussions.microsoft.com> wrote:

>Thamk you for this formula
>however, i would like my result to read in the following format (ex: 4-6-8)
>
>can you help me tune the formula
>
>thanks

Here's one way:

=INT(A1)&"-"&INT(MOD(A1,1)*12)&"-"&ROUND(MOD(MOD(A1,1)*12,1)*16,0)


--ron