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