Convert minutes into hours

[Paul]

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

 

[Teethless mama]

=A1/1440

format cell as: h:mm

 

[juliejg1]

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

 

[Dave Peterson]

24 hours per day.
60 minutes per hour.

=24*60=1440 minutes per day.

And time is just a fraction of a day.

1 hour is 1/24
and 1 minute is 1/(24*60)