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

I know this works...but why 1440? What is the significance of this number?

"Teethless mama" wrote:

=A1/1440

format cell as: h:mm

"Paul" wrote:

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