View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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