| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert total minutes to hours and minutes | Excel Discussion (Misc queries) | |||
| Convert Decimal hours and Minutes to minutes please. | Excel Worksheet Functions | |||
| How do I convert 184 minutes into 3:04 (3 hours:4 minutes) in EXCE | Excel Discussion (Misc queries) | |||
| Convert a number of minutes like 400 into hours and minutes | Excel Worksheet Functions | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
Linear Mode
