Quote:
Originally Posted by Spencer101
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!