View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default 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?