View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Holsapple Holsapple is offline
external usenet poster
 
Posts: 3
Default Time conversions

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