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
 
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

Similar Threads

Excel Formula for adding training times. 1
Converting time to decimal format 17
Converting hour/minutes to hours/hundredths 1
coverting minutes to hours and minutes 1
Convert minutes into hours and minutes 6
Displaying hours and minutes 3
Text to Numbers 3
Is there a simple formula to convert time in hundredths to minute 10

Top