I've never heard of a 30 data point limit. I just filled column A with
numbers and placed =Average(A1:A65535) in cell A65536 and it worked
fine. Where did you see information that states you can't do this?
Did you try?

- John



LoriG wrote:
Trying to get the average of over one hunded times, in hours and minutes
format. Excel says that the Average function will not work for over thirty
data points. It works for other spreadsheets, where I have fewer time points.
How do you average more than 30 data points?