Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting architectural units
I'm trying to convert 2'-8" to 32 in Excel. Any ideas? Thanks a TON
to anyone that can help. -m |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting architectural units
I don't know how generalized the technique needs to be, but for the specific
construct you show: Demo'd from the immediate window sStr = "2'-8""" ? sStr 2'-8" varr = split(sStr,"-") ? val(varr(0))*12 + val(varr(1)) 32 Assumes xl2000 or later -- Regards, Tom Ogilvy "Mike" wrote in message m... I'm trying to convert 2'-8" to 32 in Excel. Any ideas? Thanks a TON to anyone that can help. -m |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting Time to units | Excel Worksheet Functions | |||
Units Produced / (finish time minus start time)=Units Per Hr | Excel Worksheet Functions | |||
architectural fractions | Excel Discussion (Misc queries) | |||
How can a cell be formatted to display architectural units? | Excel Discussion (Misc queries) | |||
Provide Excel format for architectural units: ft-inches-fractions | Excel Discussion (Misc queries) |