Convert Function
 

I understand that there is a function (CONVERT) that converts feet to inches
and vise-versa. BUT is there a modification of that function that will
convert inches to a COMBINATION of Feet and Inches? (ie: Convert a value of
67 to 5'7")

Convert Function
 

Try this:

=IF(A1="","",IF(A1<12,"0' "&A1&"""",INT(A1/12)&"' "&MOD(A1,12)&""""))

A1 = 67

Returns: 5' 7"

I've written it so that if A1 is less than 1 foot the result will be like
this:

A1 = 7

Returns: 0' 7"

Biff

"jayceejay" wrote in message
...
I understand that there is a function (CONVERT) that converts feet to
inches
and vise-versa. BUT is there a modification of that function that will
convert inches to a COMBINATION of Feet and Inches? (ie: Convert a value
of
67 to 5'7")

Convert Function
 

SLICK! Thanks Biff!
(Loved you in "Back to the Future")

"Biff" wrote:

Try this:

=IF(A1="","",IF(A1<12,"0' "&A1&"""",INT(A1/12)&"' "&MOD(A1,12)&""""))

A1 = 67

Returns: 5' 7"

I've written it so that if A1 is less than 1 foot the result will be like
this:

A1 = 7

Returns: 0' 7"

Biff

"jayceejay" wrote in message
...
I understand that there is a function (CONVERT) that converts feet to
inches
and vise-versa. BUT is there a modification of that function that will
convert inches to a COMBINATION of Feet and Inches? (ie: Convert a value
of
67 to 5'7")

Convert Function
 

You're welcome. Thanks for the feedback!

Biff

"jayceejay" wrote in message
...
SLICK! Thanks Biff!
(Loved you in "Back to the Future")

"Biff" wrote:

Try this:

=IF(A1="","",IF(A1<12,"0' "&A1&"""",INT(A1/12)&"' "&MOD(A1,12)&""""))

A1 = 67

Returns: 5' 7"

I've written it so that if A1 is less than 1 foot the result will be like
this:

A1 = 7

Returns: 0' 7"

Biff

"jayceejay" wrote in message
...
I understand that there is a function (CONVERT) that converts feet to
inches
and vise-versa. BUT is there a modification of that function that will
convert inches to a COMBINATION of Feet and Inches? (ie: Convert a
value
of
67 to 5'7")