Calculate Average Minutes

angelh55 · May 8th, 2002, 05:59 PM

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 · May 8th, 2002, 06:05 PM

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 05:59 PM	#1
angelh55 New Member Join Date: May 2002 Location: Angel Posts: 2	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

May 8th, 2002, 06:05 PM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,319	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: =A11440 Format the cell as General before copying. And I also need an AVERAGE minutes at the bottom of column B.* =AVERAGE(B1:B6)