| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concerting total minutes to hours and minutes
I have a column of minutes which totals 500 minutes.
I want to convert it to hours and minutes. What formula can I use to get it to the 8 hours 20 mins. Also what should my cells be formatted as? Is there a way to bypass the total minutes all together and have it compute directly into the 8 hours 20 mins? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concerting total minutes to hours and minutes
=A1/1440
Format cell as h:mm "Randi" wrote: I have a column of minutes which totals 500 minutes. I want to convert it to hours and minutes. What formula can I use to get it to the 8 hours 20 mins. Also what should my cells be formatted as? Is there a way to bypass the total minutes all together and have it compute directly into the 8 hours 20 mins? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concerting total minutes to hours and minutes
If you have 500 in A2, use =A2/(24*60) and format as time.
Alternatively, just enter the data as 8:20 (using a colon as the separator). -- David Biddulph "Randi" wrote in message ... I have a column of minutes which totals 500 minutes. I want to convert it to hours and minutes. What formula can I use to get it to the 8 hours 20 mins. Also what should my cells be formatted as? Is there a way to bypass the total minutes all together and have it compute directly into the 8 hours 20 mins? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concerting total minutes to hours and minutes
The cells that I am adding are in mins. Is there a way to just have "20"
mins in a cell rather than 0:20? "Teethless mama" wrote: =A1/1440 Format cell as h:mm "Randi" wrote: I have a column of minutes which totals 500 minutes. I want to convert it to hours and minutes. What formula can I use to get it to the 8 hours 20 mins. Also what should my cells be formatted as? Is there a way to bypass the total minutes all together and have it compute directly into the 8 hours 20 mins? Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concerting total minutes to hours and minutes
Actually, upon further reflection, I need to change the total minutes into
the hours and minutes. Otherwise I have to re-enter all the data. I can divide total minutes by 60 - but what formula can I use to get the minutes correctly, i.e., 500 total minutes/ 60 = 8.33; .33 x 60 = 19.8 or 20 minutes rounded up. Thanks "Teethless mama" wrote: =A1/1440 Format cell as h:mm "Randi" wrote: I have a column of minutes which totals 500 minutes. I want to convert it to hours and minutes. What formula can I use to get it to the 8 hours 20 mins. Also what should my cells be formatted as? Is there a way to bypass the total minutes all together and have it compute directly into the 8 hours 20 mins? Thanks. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concerting total minutes to hours and minutes
That works. Thanks for your help.
"David Biddulph" wrote: If you have 500 in A2, use =A2/(24*60) and format as time. Alternatively, just enter the data as 8:20 (using a colon as the separator). -- David Biddulph "Randi" wrote in message ... I have a column of minutes which totals 500 minutes. I want to convert it to hours and minutes. What formula can I use to get it to the 8 hours 20 mins. Also what should my cells be formatted as? Is there a way to bypass the total minutes all together and have it compute directly into the 8 hours 20 mins? Thanks. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concerting total minutes to hours and minutes
No problem
=MOD(A1/60,1)*60 format cell as General "Randi" wrote: The cells that I am adding are in mins. Is there a way to just have "20" mins in a cell rather than 0:20? "Teethless mama" wrote: =A1/1440 Format cell as h:mm "Randi" wrote: I have a column of minutes which totals 500 minutes. I want to convert it to hours and minutes. What formula can I use to get it to the 8 hours 20 mins. Also what should my cells be formatted as? Is there a way to bypass the total minutes all together and have it compute directly into the 8 hours 20 mins? Thanks. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concerting total minutes to hours and minutes
If you want to convert from minutes to decimal hours, you can divide by 60
(either using a formula or using Paste Special/ Divide). If you want to convert to Excel time (which you can format as hours and minutes), then divide your minutes by 1440 as suggested below (i.e. 24*60). -- David Biddulph "Randi" wrote in message ... Actually, upon further reflection, I need to change the total minutes into the hours and minutes. Otherwise I have to re-enter all the data. I can divide total minutes by 60 - but what formula can I use to get the minutes correctly, i.e., 500 total minutes/ 60 = 8.33; .33 x 60 = 19.8 or 20 minutes rounded up. Thanks "Teethless mama" wrote: =A1/1440 Format cell as h:mm "Randi" wrote: I have a column of minutes which totals 500 minutes. I want to convert it to hours and minutes. What formula can I use to get it to the 8 hours 20 mins. Also what should my cells be formatted as? Is there a way to bypass the total minutes all together and have it compute directly into the 8 hours 20 mins? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
| Convert total minutes to hours and minutes | Excel Discussion (Misc queries) | |||
| Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
| add hours & minutes to other hours & minutes to receive total hou. | Excel Worksheet Functions | |||
| add column of minutes, show total in hours & minutes | Excel Worksheet Functions | |||
Linear Mode
