=TIME(,A2,) and format as h:mm or
=A2/24/60 and format as h:mm

Assuming that you don't want "1 hour and 15 minutes" but would prefer h
"hours and" mm "minutes" , you could use custom formatting:
h "hours and" mm "minutes"
which would give
"1 hours and 05 minutes".

It would be slightly more complicated to get a distinction between 1 "hour"
and 2 or more "hours", but it could be done. You could, of course, cheat
and format as
h "hour(s) and" mm "minutes"
--
David Biddulph

"PSULionRP" wrote in message
...
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