Feet adn Inches in Excel

[Anonymous]

Do you guys/gals know how to add feet and inches in an excel spreadsheet

example:

cell 1 cell 2 cell 3
2'2-3/4" + 1'3-1/4" = 3'6"

thanks in advance

court myers

[Anonymous]

Format the cells as Fractions. There are units under type you can use for
eights, sixteenths or whatever.

Bud Miller
www.BudCAD.com
Legal Descriptions. Parcel Reports.
Point Group Automation. Layer Reports.
Custom routines and consulting.

"Court Myers" wrote in message
news:98F90FACA2CAE2FEA0A89B2D987F0EF3@in.WebX.maYIadrTaRb...
> Do you guys/gals know how to add feet and inches in an excel spreadsheet
>
> example:
>
> cell 1 cell 2 cell 3
> 2'2-3/4" + 1'3-1/4" = 3'6"
>
> thanks in advance
>
> court myers
>
>

[cprettyman]

no good, it stil doesn't understand the feet and inches part.

[Anonymous]

I believe the best you can do is enter the numbers as decimal and use a
custom number format to display feet-inches. Though I think to do it
correctly you would need to create a custom Excel function.
http://www.pcmag.com/article2/0,4149,669528,00.asp

Dan


"Bud Miller" wrote in message
news:27EBF412C2D1FB275242F602940AA195@in.WebX.maYIadrTaRb...
> Format the cells as Fractions. There are units under type you can use for
> eights, sixteenths or whatever.
>
> Bud Miller
> www.BudCAD.com
> Legal Descriptions. Parcel Reports.
> Point Group Automation. Layer Reports.
> Custom routines and consulting.
>
> "Court Myers" wrote in message
> news:98F90FACA2CAE2FEA0A89B2D987F0EF3@in.WebX.maYIadrTaRb...
> > Do you guys/gals know how to add feet and inches in an excel spreadsheet
> >
> > example:
> >
> > cell 1 cell 2 cell 3
> > 2'2-3/4" + 1'3-1/4" = 3'6"
> >
> > thanks in advance
> >
> > court myers
> >
> >
>
>

[Anonymous]

It can be made to if you use one cell for
feet, another for inches and a little If statement.

Bud Miller

href="http://www.BudCAD.com">www.BudCAD.com
Legal Descriptions, Parcel
Reports
Layer Reports, Point Group Automation
and
more.

[Anonymous]

Actually I guess you'd need 2 IF
formulas.

If column A was Feet and B inches
(formatted as a fraction) (the two together being the first length)
column C was Feet and D inches (fomatted as a fraction)(those two together being
the second length) then you could have:

A(Feet) B(Inches) C(Feet) D(Inches) E(Total Feet)
F(Total Inches)

Then column E could add the feet (+1 if the
inches totaled more than 12):

=IF(B1+D1<12,A1+C1,A1+C1+1)

and F would add the inches and keep them under 12
(the feet would already have been incremented if the inches were >
12):

=IF(B1+D1<12,B1+D1,B1+D1-12)

Bud Miller

href="http://www.BudCAD.com">www.BudCAD.com
Legal Descriptions, Parcel
Reports
Layer Reports, Point Group Automation
and
more.

[Anonymous]

I posted an example to customer files, look for Plot Limits Spread Sheet.

By changing the viewable size along the top (blue font) the value will
change for each scale (yellow cell area). This value is given in Feet/Inches
simply select any of these cells to see the formula.

If using a NNTP newsgroup reader, the CUSTOMER FILES newsgroup can be found
at
news://discussion.autodesk.com/autodesk.autocad.customer-files

You may also access this discussion group via the HTTP web-based forums at
http://discussion.autodesk.com/WebX?14@@.ee940b5

--

Chip Harper
Member of the AutoDesk Discussion Forum Moderator Program

[Anonymous]

Cell A1:
value in decimal feet

Cell B1:
=ROUND((INT((A1*12)/12)*100+MOD((A1*12),12))*16,0)/16

Format this cell as custom: #0'-00 ??/??"''"

Result in Cell B1:

107'-11 3/16''
-----------------------------------------------------------------
Cell A1:
value in decimal inches

Cell B1:
=ROUND((INT((A1)/12)*100+MOD((A1),12))*16,0)/16

Format this cell as custom: #0'-00 ??/??"''"
or if you want to keep inches: #0 ??/??"''"


HTH
--
- Jeff

[AutoCAD 2000 / 2000 LT / 2002; WINNT 4, SP 6; 1 gig RAM; Matrox Millennium
AGP]
**********************************************
"Court Myers" wrote in message
news:98F90FACA2CAE2FEA0A89B2D987F0EF3@in.WebX.maYIadrTaRb...
> Do you guys/gals know how to add feet and inches in an excel spreadsheet
>
> example:
>
> cell 1 cell 2 cell 3
> 2'2-3/4" + 1'3-1/4" = 3'6"
>
> thanks in advance
>
> court myers
>
>