Convert minutes to hours and minutes

[Guest]

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??

 

[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

 

[Guest]

I am sorry in the example 1.5 is 1 hour and 50 minutes.

 

[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

 

[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)

 

[Guest]

YOU DID IT!!!!!

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

Sally