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
|