converting formula for whole numbers to time
 

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

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

converting formula for whole numbers to time
 

Hi Bob:

Try

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

and then format the cell as time.

--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK
Please do not forget to rate this reply.


"vdmbqb" wrote:

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

converting formula for whole numbers to time
 

=A1/(24*60) and format as time.
--
David Biddulph


"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

converting formula for whole numbers to time
 

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


"vdmbqb" wrote:

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