View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Paul is offline
external usenet poster
 
Posts: 661
Default Convert minutes into hours

How can I convert minutes into hours and minutes? For example: 235 minutes to
give me the result of 3 hours and 55 minutes. Besides the formula, is there
any special formatting of the cells needed?
Thanks