Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formula for length?
I work a lot with measurements mostly in inches, but I have found a need to
convert them to feet and inches quickly, is there a macro or formula to do this? -- Peace to you, Bill |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formula for length?
You might check out the Convert() function in the Help files.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Bill" wrote in message ... I work a lot with measurements mostly in inches, but I have found a need to convert them to feet and inches quickly, is there a macro or formula to do this? -- Peace to you, Bill |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formula for length?
Hi!
There's nothing built in so you have to write your own formula. That formula depends on the format you use. Post several examples and we'll see what we can come up with. Biff "Bill" wrote in message ... I work a lot with measurements mostly in inches, but I have found a need to convert them to feet and inches quickly, is there a macro or formula to do this? -- Peace to you, Bill |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formula for length?
See Chip Pearson's site for working with feet and inches.
http://www.cpearson.com/excel/FeetInches.htm Note the link on that page to Fractional Arithmetic. Gord Dibben MS Excel MVP On Tue, 18 Jul 2006 17:30:02 -0700, Bill wrote: I work a lot with measurements mostly in inches, but I have found a need to convert them to feet and inches quickly, is there a macro or formula to do this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formula for length?
Bill wrote: I work a lot with measurements mostly in inches, but I have found a need to convert them to feet and inches quickly, is there a macro or formula to do this? Bill, copy this function into a macro module: Public Function ConvertFeet(ByVal Inches As Double) As String Dim Feet As Double Feet = Int(Inches / 12) ConvertFeet = Str(Feet) & "'" & Str(Inches - Feet * 12) & """" End Function You can then address the function whenever you want within your spreadsheet. e.g. If cell A1 contains the value 108 (inches) and you type =convertfeet(A1) into cell A2 it will return the answer 9' 0" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |