On Tuesday, February 5, 2013 at 5:29:00 PM UTC-6, Cory Boyd wrote:
Spencer101;1609135 Wrote:
I may be missing something fundamental here, but that looks like the
right answer to me. What are you expecting it to be?

Just to test it, put this formula in cell E2 and copy down.
=AVERAGE(D$2:D2)
It will allow you to see the running average and by the time you get to
cell
E7 you will have your 22'.56" average.

it was the f.ii notation gumming things up. the # ??/12 custom format
was a good fix.

Thank you both for your help!




--
Cory Boyd


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?