View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Averaging feet and inches (not decimal feet)


The # ??/12 is a good way to enter in the numbers, but does anyone
have the equation then for figuring the averages of those numbers.
Mine is making me enter them as decimals (12.25 then automatically
converts to 12 3/12. It still works, just need to know what decimal
equals each inch out of 12). Is there any way to enter them in this
format 12 3/12 and have them automatically calculate the avg. in the
same format?


Strange format! 12 3/12 is actually 12 1/4 (decimal value 12.25
converted to fraction)...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion