converting formula for whole numbers to time
For C31, use:
=B31/60/24
Format as a time (eg, h:mm).
Regards,
Fred
"vdmbqb" wrote in message
...
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
|