View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Julleanna Julleanna is offline
external usenet poster
 
Posts: 4
Default 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?