Calculate Average Minutes

[angelh55]

Is there a way to formulate average minutes?
Example:
A B C D
1 1:24
2 7:15
3 9:59
4 5:14
5 0:25
6 0:18

At the bottom of of column A, I can get a SUM of time. I need to be able to get an AVERAGE of time in hours & minutes.

I also need for cell (B1) equal number of minutes from cell (A1). So that 1:24 in cell (A1) reads 84 minutes in cell (B1).

And I also need an AVERAGE minutes at the bottom of column B.

I appreciate any input you can provide.

Thanks
Angel

 

[Aladin Akyurek]

On 2002-05-08 16:59, angelh55 wrote:
Is there a way to formulate average minutes?
Example:
A B C D
1 1:24
2 7:15
3 9:59
4 5:14
5 0:25
6 0:18

At the bottom of of column A, I can get a SUM of time. I need to be able to get an AVERAGE of time in hours & minutes.

=AVERAGE(A1:A6)

Custom format the cell of this formula as

[h]:mm

I also need for cell (B1) equal number of minutes from cell (A1). So that 1:24 in cell (A1) reads 84 minutes in cell (B1).

In B1 enter and copy down:

=A1*1440

Format the cell as General before copying.

And I also need an AVERAGE minutes at the bottom of column B.

=AVERAGE(B1:B6)