Thread: Average
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Fishbonker Fishbonker is offline
external usenet poster
 
Posts: 4
Default Average

Excell 2003

I'm trying to average times, in minutes, in a single column. The minutes are
the result of a formula to find elapsed times (14:10-14:08 etc). There are
1414 cells in the column with entries in about 80% of the cells. In one of
the books I have it says Excell will only average 20 numbers. If this is
true, how do I average the column?

On a relaterd topic, wehn I try to do MAX for the columns I get a number
that I know isn't the MAX for that column.

I've got the columns formated for times.

What am I doin wrong?

Thanks,

The 'Bonker
--
Its better to remain silent and be thought a fool than open ones mouth and
remove all doubt. Creditied to Mark Twain.

So I guess I''ve removed all doubt.