| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can you convert hours into minutes?
I would like to figure out how long it took to complete a task in minutes
instead of hours. For example Start time 7:15 AM End Time 9:25 AM. I want to convert instead of 2:10 minutes I want it to be 135 minutes. Any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can you convert hours into minutes?
On Tue, 15 Nov 2005 10:37:32 -0800, "Henry"
wrote: I would like to figure out how long it took to complete a task in minutes instead of hours. For example Start time 7:15 AM End Time 9:25 AM. I want to convert instead of 2:10 minutes I want it to be 135 minutes. Any suggestions? =EndTime - StartTime Format the cell as Format/Cells/Number/Custom Type: [m] --ron |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can you convert hours into minutes?
If you want the numeric result (rather than adjusting the format as Ron
correctly suggests), you could multiply the result by 1440 (the number of minutes in a day), and format the results as a normal number. "Henry" wrote: I would like to figure out how long it took to complete a task in minutes instead of hours. For example Start time 7:15 AM End Time 9:25 AM. I want to convert instead of 2:10 minutes I want it to be 135 minutes. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| How do I convert a number of minutes into hours and minutes? | Excel Worksheet Functions | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
| How can I convert fractional hours to minutes? | Excel Discussion (Misc queries) | |||
| convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
Hybrid Mode
