Convert minutes to hours and minutes

S

Sally IC

I have a formula that converts whole numbers with a decimal to minutes. Example 1.5 =110 minutes. I am trying to convert the total minutes back to a whole number with a decimal in minutes. For example 110 minutes = 1.5. If I divide the minutes by 60 I get 1.83 where I want to get back to the 1.5. Does anyone know the formula to do this??
 
F

Frank Kabel

Hi Sally
maybe I'm missing smething but how did you convert
1.5 to 110 minutes (I had suspected 90 minutes??)

So the value 1.83.. (1,83 hours) is correct for 110 minutes (if
converted to decimals)

Frank
 
F

Frank Kabel

Hi Sally
do you net the decimal point as separator. I would really recommend
using Excel's default formats. That is using the colon.
Try using the formula:
=TIME(0,110,0)
and format the sesulting cell as 'Time'. This will result in '01:50'

Frank
 
B

Bob Phillips

Sally,

Try this

=INT(H1/60)+(H1-INT(H1/60)*60)/100

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
S

Sally

YOU DID IT!!!!!

THANK YOU SO MUCH, I have racked my brain on this for a couple of days!

Sally
 
Top