View Single Post
  #1   Report Post  
Kyle
 
Posts: n/a
Default Multiply cell with foot and inch

How do I format a cell for user to enter in ft and inch
format such as 4'33". Then how do I multiply 2 cell
together to produce square foot. Example A1=4'33" and
B1=3'33" which is equal 14.42 Sq.Ft.

Thanks.