View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default 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?