software

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),quot; 0 quot;quot;feet quot;quot;quot;)amp;INT(MOD(D18,1)*12)amp;quot;
quot;amp;TEXT(MOD(D18*12,1),quot;0/16quot;)amp;quot; inchesquot;

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;tvquot; gt; wrote in message
...
gt; I would like to write a formula in excel, without using macros, to convert
gt; decimal feet to feet-inch-sixteenths.
gt;
gt; Can someone help me ?

quot;tvquot; gt; wrote in message
...
gt;I would like to write a formula in excel, without using macros, to convert
gt; decimal feet to feet-inch-sixteenths.
gt;
gt; Can someone help me ?

Are you able to write the formula on paper first?
Decimal value in A1, formula in B1:=INT(A1) amp; quot; ft quot; amp; TEXT(MOD(A1,1)*12, quot;# ??/16quot;) amp; quot;inquot;

A1=2.345 (ft)

B1=2 ft 4 2/16 in

HTH

quot;tvquot; wrote:gt; I would like to write a formula in excel, without using macros, to convert
gt; decimal feet to feet-inch-sixteenths.
gt;
gt; Can someone help me ?

Whilst I concede that yours is much better than mine, it can still be
improved upon lt;vbggt;

=INT(A1) amp; quot; ft quot; amp; TEXT(MOD(A1,1)*12, quot;# ??/16 quot;quot;inquot;quot;quot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Toppersquot; gt; wrote in message
...
gt; Decimal value in A1, formula in B1:
gt;
gt;
gt; =INT(A1) amp; quot; ft quot; amp; TEXT(MOD(A1,1)*12, quot;# ??/16quot;) amp; quot;inquot;
gt;
gt; A1=2.345 (ft)
gt;
gt; B1=2 ft 4 2/16 in
gt;
gt; HTH
gt;
gt; quot;tvquot; wrote:
gt;
gt;
gt; gt; I would like to write a formula in excel, without using macros, to
convert
gt; gt; decimal feet to feet-inch-sixteenths.
gt; gt;
gt; gt; Can someone help me ?
Bob,
I'm flattered!

quot;Bob Phillipsquot; wrote:

gt; Whilst I concede that yours is much better than mine, it can still be
gt; improved upon lt;vbggt;
gt;
gt; =INT(A1) amp; quot; ft quot; amp; TEXT(MOD(A1,1)*12, quot;# ??/16 quot;quot;inquot;quot;quot;)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Toppersquot; gt; wrote in message
gt; ...
gt; gt; Decimal value in A1, formula in B1:
gt; gt;
gt; gt;
gt; gt; =INT(A1) amp; quot; ft quot; amp; TEXT(MOD(A1,1)*12, quot;# ??/16quot;) amp; quot;inquot;
gt; gt;
gt; gt; A1=2.345 (ft)
gt; gt;
gt; gt; B1=2 ft 4 2/16 in
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; quot;tvquot; wrote:
gt; gt;
gt; gt;
gt; gt; gt; I would like to write a formula in excel, without using macros, to
gt; convert
gt; gt; gt; decimal feet to feet-inch-sixteenths.
gt; gt; gt;
gt; gt; gt; Can someone help me ?
gt;
gt;
gt;

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

quot;Toppersquot; wrote:

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

On Tue, 7 Mar 2006 13:27:26 -0800, tv gt; wrote:

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

Here's one way:

=INT(A1)amp;quot;-quot;amp;INT(MOD(A1,1)*12)amp;quot;-quot;amp;ROUND(MOD(MOD(A1,1)*12,1)*16,0)--ron

I found your question very similar to one our school nurse has posed: When
our gym teachers measure students they report students' height in inches only
ie 61quot;. Might their be a formula that would convert 61 inches (61quot;) to 5' 1quot;?
--
Thanks for your helpquot;tvquot; wrote:

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

On Mon, 19 Nov 2007 18:31:03 -0800, John A gt;
wrote:

gt;I found your question very similar to one our school nurse has posed: When
gt;our gym teachers measure students they report students' height in inches only
gt;ie 61quot;. Might their be a formula that would convert 61 inches (61quot;) to 5' 1quot;?

Assuming whole inches only:

=INT(A1/12)amp;quot; ft, quot;amp;MOD(A1,12)amp;quot; inchesquot;

or,

=INT(A1/12)*100 MOD(A1,12)

and custom format:

Format/Cells/Number/Custom Type: 0' 00\quot;

If you want to report to tenths of an inch, change the Custom format to
0' 00.0\quot;--ron