Conversion Formula
 

Im looking for a formula to convert distance.

Example:
60.625 to 5 3/8€�

Is this possible?
Can someone help me?

Conversion Formula
 

The closest I can easily get is =INT(A1/12)&"'
"&INT(MOD(A1,12))&TEXT(MOD(A1,1),"# ?/?")&""""
which gives 5' 0 5/8"
--
David Biddulph

"dawg" wrote in message
...
I'm looking for a formula to convert distance.

Example:
60.625 to 5' 3/8"

Is this possible?
Can someone help me?

Conversion Formula
 

0.625 = 5/8

Will the full inches *ALWAYS* be a multiple of a full foot? Will you have
entries like:

1.25
8.50
0.75
13.125

Biff

"dawg" wrote in message
...
I'm looking for a formula to convert distance.

Example:
60.625 to 5' 3/8"

Is this possible?
Can someone help me?

Conversion Formula
 

Suggest this modified version:

=INT(A1/12)&"'
"&INT(MOD(A1,12))&IF(MOD(A1,1),TEXT(MOD(A1,1), "??/??")&"""","""")

Biff

"David Biddulph" wrote in message
...
The closest I can easily get is =INT(A1/12)&"'
"&INT(MOD(A1,12))&TEXT(MOD(A1,1),"# ?/?")&""""
which gives 5' 0 5/8"
--
David Biddulph

"dawg" wrote in message
...
I'm looking for a formula to convert distance.

Example:
60.625 to 5' 3/8"

Is this possible?
Can someone help me?