I am using Office 2007.

In column A I have a list of thirty activities. In column B I have the
amount of minutes each activity took to complete. In cell B31 I have the
total number of minutes from B1:B30. This number appears as a whole number.
For instance 59 minutes appears as 59 and 65 minutes appears as 65.

I need a formula in C31 that will convert the number in B31 to an Hrs and
minutes format.

For instance 59=:59 65=1:05

Thank you (VERY MUCH) in advance.

--
bob