View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
colette colette is offline
external usenet poster
 
Posts: 16
Default Converting total minutes into hours and minutes in Excel

I have a project which only gives me minutes. I need to convert the total
minutes to hours and minutes. Example: 127 is the number (total minutes).
I need it to read it took 2 hours and 7 minutes to complete. Needs to look
like this 2:07