ExcelBanter - Convert minutes into hours

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Convert minutes into hours (https://www.excelbanter.com/excel-worksheet-functions/174997-convert-minutes-into-hours.html)

Paul

Convert minutes into hours

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

Convert minutes into hours

=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

juliejg1

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

Dave Peterson

Convert minutes into hours

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)

juliejg1 wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 08:23 AM.