converting formula for whole numbers to time

[vdmbqb]

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.

 

[Fred Smith]

For C31, use:
=B31/60/24
Format as a time (eg, h:mm).

Regards,
Fred

 

[Martin Fishlock]

Hi Bob:

Try

=TIME(B31/60,MOD(B31,60),0)

and then format the cell as time.

 

[JMay]

=A1/(24*60) Format: Custom h:mm