converting minutes to hours

[Guest]

Hello everyone...again

Having trouble with the last formula I need for this worksheet. This one is a bit tricky. If the user enters in a whole number in cellA, say 1 (which equals 5 minutes), cellB has to display based on cellA, the value in hours(in decimal form). so if a user enters in 6 in cellA, cellB would display .5 hours. This is possible, right?

Any help or suggestions would be apprecaited
Mike

 

[Frank Kabel]

Hi
try the following in B1
=TIME(0,A1*5,0)
and format the cell B1 as 'Time'
or
enter the formula
=(A1*5)/(24*60)
and also format as 'Time'

--
Regards
Frank Kabel
Frankfurt, Germany

Hello everyone...again,

Having trouble with the last formula I need for this worksheet. This

one is a bit tricky. If the user enters in a whole number in cellA,
say 1 (which equals 5 minutes), cellB has to display based on cellA,
the value in hours(in decimal form). so if a user enters in 6 in
cellA, cellB would display .5 hours. This is possible, right??

 

[Dave R.]

A fairly intuitive way...

=(A1*5)/60

Hello everyone...again,

Having trouble with the last formula I need for this worksheet. This one

is a bit tricky. If the user enters in a whole number in cellA, say 1
(which equals 5 minutes), cellB has to display based on cellA, the value in
hours(in decimal form). so if a user enters in 6 in cellA, cellB would
display .5 hours. This is possible, right??