adding feet and inches

[vitruviuz]

trying to create an excel spreadsheet that adds feet (') and inches (")
but do not see in the format cell options a category for this.
is it possible to add feet and inches, if so how do you do i

 

[Scott]

Hi vitruviuz

I know this isn't exactly what you wanted, but maybe it'll help

One way format as twelveths # ?/1

Second wa
If you REALLY want to use ' and '' (note I'm using 2 times ' for '', not SHIFT ') you can multiply everything by 365 and use yy' m'', but it's messy and if your feet are between 0 and 9, it'll show a 0 in the tenth's place ex: 04' 10'' Also, if you go above 100 feet, bad things can happen (It'll only show the last 2 digits.

The first way works great, but doesn't look nice

Third wa
Alternatively, if you've got specific decimal feet in A1 and want it to look nice in another cell, use

=(FLOOR(A1,1))&"' "&ROUND((A1-FLOOR(A1,1))*12,0)&"''

and it work beautifully for me. Keep in mind that this way, and the second way, look like you want (well for the second way, some of the time) but they're not very useful for computational purposes. The first way works fine for adding/subtracting

Have fun
Scot

----- vitruviuz > wrote: ----

trying to create an excel spreadsheet that adds feet (') and inches (")
but do not see in the format cell options a category for this
is it possible to add feet and inches, if so how do you do i

 

[Mark Graesser]

Take a look at Chip Pearson's site

http://www.cpearson.com/excel/fractional.ht

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- vitruviuz > wrote: ----

trying to create an excel spreadsheet that adds feet (') and inches (")
but do not see in the format cell options a category for this
is it possible to add feet and inches, if so how do you do i

 

[Gord Dibben]

See answer in exc excel.misc NG

No need to multi-post. All the regulars monitor all the groups.

Multi-posting just duplicates efforts of all. If you "must" post to more than
one NG use cross-posting instead. That way we can see the posting has been
posted to more than one group.

Gord Dibben Excel MVP