Convert minutes into hours

  • Thread starter Thread starter Paul
  • Start date Start date
P

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
 
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)
 
Back
Top