THANK YOU SOOOOOOOOOO MUCH. That was it. You saved me like 5 hours.

"Bernard Liengme" wrote:

Assuming you meant 39.20 not 39:20, try
=INT(A1)+ROUND(MOD(A1,1)*100/60,2)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Holsapple" wrote in message
...
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?????????