| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conversion Formula
Im looking for a formula to convert distance.
Example: 60.625 to 5 3/8�� Is this possible? Can someone help me? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Automatic Formula to Value Conversion | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Linear Mode
