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.

Average
 

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
DTHIS
www.nickhodge.co.uk


"Fishbonker" wrote in message
...
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.

Average
 

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.
--
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.


"Nick Hodge" wrote:

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
DTHIS
www.nickhodge.co.uk


"Fishbonker" wrote in message
...
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.

Average
 

Try highlighting the formula cell and going to FormatCellCustom and enter
mm:ss

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Fishbonker" wrote in message
...
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.
--
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.


"Nick Hodge" wrote:

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
DTHIS
www.nickhodge.co.uk


"Fishbonker" wrote in message
...
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.