| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating totals of material with feet and inches
I'm setting up a spread sheet for bill of materials. Let's say I have
3x3x1/4 material at 1' 10 3/8" each and 3x3x1/4 at 5' 4 1/8" each. I want Excel to calculate total in feet and inches. Bascially variable sizes. I am not sure how to write this so that I can use it for other materials. I need to find out the total of the material to order. Is there any easy way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting from feet, inches and fractions to inches and decimal p | Setting up and Configuration of Excel | |||
| Feet, inches and fractions to inches and dec.....reposting for Pet | Setting up and Configuration of Excel | |||
| Is there a formula for inches to feet and inches? | Excel Worksheet Functions | |||
| is there a macro that will convert from inches to feet and inches | Excel Discussion (Misc queries) | |||
| Calculating the Area of objects in Feet and Inches | Excel Discussion (Misc queries) | |||
Threaded Mode
