View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joshua joshua is offline
external usenet poster
 
Posts: 25
Default convert hours and minutes into days

I have a formula in a cell that adds up a bunch of hours and minutes and is
in the [h]:mm format, it gives me a total of 48:00

How do I get display that information, in another cell, and give me how many
days that is like, which would be 2 days