How can i convert feet-inches to just feet in excel
How can i convert feet-inches to just feet in excel
(OP)
Hi folks,
I was wondering how do i convert 5'-9" to 5.75 ft in excel. Any help is appreciated.
Ted.
I was wondering how do i convert 5'-9" to 5.75 ft in excel. Any help is appreciated.
Ted.
RE: How can i convert feet-inches to just feet in excel
Is this a column of ft-in dimensions?
If so I'd REPLACE the ' & " characters with nothing and then use Data > Text to columns DELIMITED by -, so you have a column for ft and another for in.
Then it's a simple formula.
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: How can i convert feet-inches to just feet in excel
I need the fee-inches to be displayed as #'-#". Do you know of a formula which can take this and convert to strictly inches or feet.
I know the formula to convert 5.75 to 5'-9" (see below), but was not able to do the reverse.
=INT(A2)&"'-"&TRIM(TEXT(ROUND(MOD(A2,1)*12*16,0)/16,"# ??/??")&"""")
RE: How can i convert feet-inches to just feet in excel
=A1&"'-"&B1&""""
where A1 is 5 B1 is 9
Result: 5'-9"
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: How can i convert feet-inches to just feet in excel
https://newtonexcelbach.wordpress.com/2014/05/31/f...
looks at various ways of converting to and from a text string containing feet and inches, using both on-sheet formulas and VBA user defined functions.
There is a download file including all the formulas:
http://interactiveds.com.au/software/Units4Excel.z...
and also a general unit conversion spreadsheet which will convert a wide range of other units, and also do unit aware evaluation:
http://interactiveds.com.au/software/Units4Excel.z...
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: How can i convert feet-inches to just feet in excel
CODE -->
If you want a custom Function ff2fi(x):
CODE -->
RE: How can i convert feet-inches to just feet in excel
I think this formula converts feet to feet-inch, i want to the opposite (convert feet-in to feet).
RE: How can i convert feet-inches to just feet in excel
thread724-365451: An Excel conversion question
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
[IMG http://tinyurl.com/7ofakss]
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
Of course I can. I can do anything. I can do absolutely anything. I'm an expert!
There is a homework forum hosted by engineering.com: http://www.engineering.com/AskForum/aff/32.aspx
RE: How can i convert feet-inches to just feet in excel
Cell formula:
CODE -->
Function
CODE -->
RE: How can i convert feet-inches to just feet in excel
Thanks you all for all your help, really appreciate it.