# formula to convert decimal feet to feet inch sixteenths

1. ## 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 ?

2. ## Re: formula to convert decimal feet to feet inch sixteenths

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 ?

3. ## Re: formula to convert decimal feet to feet inch sixteenths

"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?

4. ## RE: formula to convert decimal feet to feet inch sixteenths

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 ?

5. ## Re: formula to convert decimal feet to feet inch sixteenths

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 ?

6. ## Re: formula to convert decimal feet to feet inch sixteenths

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 ?

>
>
>

7. ## RE: formula to convert decimal feet to feet inch sixteenths

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 ?

8. ## Re: formula to convert decimal feet to feet inch sixteenths

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

9. ## Re: formula to convert decimal feet to feet inch sixteenths

=INT(MROUND(A1,1/16)/12) & "' " & TEXT(MOD(MROUND(A1,1/16),12),"#-#/##") & """"

The formula above display inches with a decimal to feet and inches with a fraction to the nearest 16th; a great test for many formula's is to enter 23.999; above it will properly display 2' 0"

The formula will display zero for feet and/or inches. e.g. 0' 0", or 2' 0", or 0' 1/16"

other display examples would be like this: 1' 2-3/16"

The MROUND function requires the Analysis Tool Pack addin to be installed; it's easy to research how if it's not installed.

10. ## Re: formula to convert decimal feet to feet inch sixteenths

Can you tell me how to do it and have it look like this (26") 2'-2" or 26" (2'-2")

11. ## Re: formula to convert decimal feet to feet inch

Can you tell me how to do it and have it look like this (26") 2'-2" or 26" (2'-2")

in that same cell I am summing up first for example- =SUM(B14*K14) then how do you write it like above?
Thx

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1