Average

[Guest]

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

 

[Nick Hodge]

These functions should work

=AVERAGE(A1:A1000)

=MAX(A1:A1000)

But you will need to make sure the cell with the formula is formatted to
mm:ss or similar

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Guest]

Thanks for the reply.

When I formated the columns I used "13:20" as the format. It is possible
that the cell the formula is in lost it's formatting. I'll see if I can
reformat the source column.

 

[Nick Hodge]

Try highlighting the formula cell and going to Format>Cell>Custom and enter
mm:ss

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk