If your formula is like this, say:

=SUM(A2:A50)

then change it to:

=SUM(A2:A50)/24/60

and then use a custom format on the cell of [h]:mm. Or you could make
the custom format:

[h]" hours and "m" minutes"

Hope this helps.

Pete



On Apr 11, 9:26*pm, PSULionRP
wrote:
I have an excel spreadsheet and I am summing the minutes. So I have total
minutes of "65". How can I get this to display as "1:05"??? Or Better Yet, "1
hour and 15 minutes"???

Any help is greatly appreciated.

Thanks!

PSULionRP