Thanks:  0
Likes:  0

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

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•