Time conversions

H

Holsapple

I am trying to convert some times in my spreadsheet. I know how to convert
mins. to hrs but the problem I am having is this for example:
I need 39.20 to show as 39.33.

Does any one know the formula or how I can do this?????????
 
B

Bernard Liengme

Assuming you meant 39.20 not 39:20, try
=INT(A1)+ROUND(MOD(A1,1)*100/60,2)
best wishes
 
Top