| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert feet & inches to decimals
example: I need to insert 3'-2" into one cell and the result shown in another
cell would be the equivalent in decimals of feet -- Estimator |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert feet & inches to decimals
=LEFT(A1,FIND("-",A1)-2)+SUBSTITUTE(MID(A1,FIND("-",A1)+1,5),"""","")/12
"Roderick" wrote: example: I need to insert 3'-2" into one cell and the result shown in another cell would be the equivalent in decimals of feet -- Estimator |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change feet/ inches to decimals | Excel Discussion (Misc queries) | |||
| How do I convert decimal to feet and inches | Excel Worksheet Functions | |||
| convert to feet and inches | Excel Discussion (Misc queries) | |||
| How do I convert Meters to Feet and Inches? | Excel Worksheet Functions | |||
| is there a macro that will convert from inches to feet and inches | Excel Discussion (Misc queries) | |||
Hybrid Mode
