Change Inches to feet and Inches

's Computer Specifications

I have a column adding inches with fractions like this:

96
4 1/4

100 1/4

How can you format the cell with 100 1/4 to show 8' 4" 1/4

Thank you for your help.

's Computer Specifications

you can try this, i just used a1:a7 as the range

=TEXT(INT(SUM(A1:A7)/12) & "' " &MOD(SUM(A1:A7),12) & """","0.00")
--

Gary

"Bob" <(E-Mail Removed)> wrote in message
news:472AF9A0-4739-46C3-A824-(E-Mail Removed)...
>I have a column adding inches with fractions like this:
>
> 96
> 4 1/4
>
> 100 1/4
>
> How can you format the cell with 100 1/4 to show 8' 4" 1/4
>
> Thank you for your help.

's Computer Specifications

One way:

=INT(SUM(A1:A3)/12) & TEXT(MOD(SUM(A1:A3),12), "' 0\"" ?/?")

In article <472AF9A0-4739-46C3-A824-(E-Mail Removed)>,
Bob <(E-Mail Removed)> wrote:

> I have a column adding inches with fractions like this:
>
> 96
> 4 1/4
>
> 100 1/4
>
> How can you format the cell with 100 1/4 to show 8' 4" 1/4
>
> Thank you for your help.

's Computer Specifications

This worked just right:
=INT(SUM(A1:A3)/12) & TEXT(MOD(SUM(A1:A3),12), "' 0\"" ?/?")the formula:

This formula leaves a decimal for the fraction.
=TEXT(INT(SUM(A1:A7)/12) & "' " &MOD(SUM(A1:A7),12) & """","0.00")

Thanks again for your help.

"JE McGimpsey" wrote:

> One way:
>
> =INT(SUM(A1:A3)/12) & TEXT(MOD(SUM(A1:A3),12), "' 0\"" ?/?")
>
> In article <472AF9A0-4739-46C3-A824-(E-Mail Removed)>,
> Bob <(E-Mail Removed)> wrote:
>
> > I have a column adding inches with fractions like this:
> >
> > 96
> > 4 1/4
> >
> > 100 1/4
> >
> > How can you format the cell with 100 1/4 to show 8' 4" 1/4
> >
> > Thank you for your help.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
change feet and inches to decimal inches	Brian 1	Microsoft Excel Worksheet Functions	4	2nd May 2009 04:02 AM
Convert inches & display as Feet Inches and Fractions -- BUG FREE	Mark Main	Microsoft Excel Worksheet Functions	9	26th Nov 2008 08:50 PM
Converting from feet, inches and fractions to inches and decimal p	=?Utf-8?B?RGVl?=	Microsoft Excel Setup	5	18th Sep 2007 04:18 PM
How do I set cell format for feet, inches, & fractions of inches?	=?Utf-8?B?c3RldmUtYg==?=	Microsoft Excel Worksheet Functions	3	30th Sep 2004 12:27 AM
how to convert feet-inches-fractions to feet (or inches) in Excel	=?Utf-8?B?Sm9obiBCYXRlcw==?=	Microsoft Excel Worksheet Functions	1	23rd Sep 2004 08:24 PM