View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron@Buy Ron@Buy is offline
external usenet poster
 
Posts: 345
Default how do i calculate 2' x 4' x 4"

Try this:
http://josh.com/InchCalc/index.htm


"PlaceCarp" wrote:

How do I calculate cubic feet in excel? I need to be able to do it two ways.
With all feet or with feet and inches. example... 2' x 4' x 3' or 2' x 4' x
1'-5" or 2' x 4' x 4". I have a construction master IV calculator that will
give me both answers in cubic feet. 2'x4'x3'= 24cubic feet or
2'x4'x1'-5"=11.33333 cu ft or 2'x4'x4"=2.6667 cu ft.

I have excel 2003 is it possible to do this and if not why these are basic
math. Also don't see any formulas that are geared towards the construction
industry. Is there an add on I can download?