Convert minutes into hours


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
 
Ad

Advertisements

J

juliejg1

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

Advertisements

D

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top