Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Wayne hof
 
Posts: n/a
Default Need formulas for adding feet, inches & fraction in one cell

If i have 12' 4" & 1/2" in cell A1 and 10' 4" &1/4" in cell A2 how do i add
or subtract them? Will excel do this or Is there a program/script or
something that will do this.
--
Wayne Hof
  #2   Report Post  
Biff
 
Posts: n/a
Default

Hi!

This could be done in the format that you have:

12' 4" & 1/2"

but the resulting formula would be a real mess!

Suggestion: drop the fraction for a decimal and get rid of
the ampersand so that the entry looks like this:

12' 4.5"

Now, use this formula to convert the measure to inches:

=(LEFT(A1,FIND("'",A1)-1)*12+SUBSTITUTE(MID(A1,FIND(" ",A1)
+1,255),"""",""))

You can perform whatever math operations you need on the
converted values and then convert them back to feet inches
with this formula:

=ROUND(INT(B1)/12,0)&"' "&MOD(B1,12)&""""

Biff

-----Original Message-----
If i have 12' 4" & 1/2" in cell A1 and 10' 4" &1/4" in

cell A2 how do i add
or subtract them? Will excel do this or Is there a

program/script or
something that will do this.
--
Wayne Hof
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate formulas with feet & inches Wayne hof Excel Worksheet Functions 10 January 30th 05 10:58 PM
Cell Formats in formulas C. Lewis Excel Discussion (Misc queries) 1 January 5th 05 07:37 PM
Converting inches to feet & inches. svech61 Excel Worksheet Functions 2 November 27th 04 05:23 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM
How can I format a cell to accept feet and inches and add them Jack Excel Worksheet Functions 4 November 4th 04 01:30 AM


All times are GMT +1. The time now is 10:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"