Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting total minutes into hours and minutes in Excel
I have a project which only gives me minutes. I need to convert the total
minutes to hours and minutes. Example: 127 is the number (total minutes). I need it to read it took 2 hours and 7 minutes to complete. Needs to look like this 2:07 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting total minutes into hours and minutes in Excel
=A1/24/60
Format cell as h:mm "Colette" wrote: I have a project which only gives me minutes. I need to convert the total minutes to hours and minutes. Example: 127 is the number (total minutes). I need it to read it took 2 hours and 7 minutes to complete. Needs to look like this 2:07 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting total minutes into hours and minutes in Excel
Try one of these:
To convert the values in place: Enter 1440 in some empty cell Now, copy that cell, Goto EditCopy Select the values to convert Goto EditPaste SpecialDivideOK Format the cells as [h]:mm Or: A1 = 127 =A1/1440 Format as [h]:mm Biff "Colette" wrote in message ... I have a project which only gives me minutes. I need to convert the total minutes to hours and minutes. Example: 127 is the number (total minutes). I need it to read it took 2 hours and 7 minutes to complete. Needs to look like this 2:07 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting total minutes into hours and minutes in Excel
If the hours will be less than 24 then use 127/60 and format the cell as time
using 24 hour clock. If the hours will be 24 or greater use =int(127/60)&":"&text(mod(127,60),"00") -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Colette" wrote: I have a project which only gives me minutes. I need to convert the total minutes to hours and minutes. Example: 127 is the number (total minutes). I need it to read it took 2 hours and 7 minutes to complete. Needs to look like this 2:07 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting total minutes into hours and minutes in Excel
No, Martin. Excel's times are in days, not hours. Colette will need to
divide by 24, as well as by 60. Your formula will give 2:48 (having lost the odd 2 days), rather than 2:07. -- David Biddulph "Martin Fishlock" wrote in message ... If the hours will be less than 24 then use 127/60 and format the cell as time using 24 hour clock. .... -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Colette" wrote: I have a project which only gives me minutes. I need to convert the total minutes to hours and minutes. Example: 127 is the number (total minutes). I need it to read it took 2 hours and 7 minutes to complete. Needs to look like this 2:07 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting total minutes into hours and minutes in Excel
In addition to Dave's comments, if hours are greater than 24, you can easily
display them using a custom format of [h]:mm. -- Regards, Fred "Martin Fishlock" wrote in message ... If the hours will be less than 24 then use 127/60 and format the cell as time using 24 hour clock. If the hours will be 24 or greater use =int(127/60)&":"&text(mod(127,60),"00") -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Colette" wrote: I have a project which only gives me minutes. I need to convert the total minutes to hours and minutes. Example: 127 is the number (total minutes). I need it to read it took 2 hours and 7 minutes to complete. Needs to look like this 2:07 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting total minutes into hours and minutes in Excel
Wow that was easy. Thank you so much.
"Teethless mama" wrote: =A1/24/60 Format cell as h:mm "Colette" wrote: I have a project which only gives me minutes. I need to convert the total minutes to hours and minutes. Example: 127 is the number (total minutes). I need it to read it took 2 hours and 7 minutes to complete. Needs to look like this 2:07 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting total minutes into hours and minutes in Excel
Thank you so much. It works.
"T. Valko" wrote: Try one of these: To convert the values in place: Enter 1440 in some empty cell Now, copy that cell, Goto EditCopy Select the values to convert Goto EditPaste SpecialDivideOK Format the cells as [h]:mm Or: A1 = 127 =A1/1440 Format as [h]:mm Biff "Colette" wrote in message ... I have a project which only gives me minutes. I need to convert the total minutes to hours and minutes. Example: 127 is the number (total minutes). I need it to read it took 2 hours and 7 minutes to complete. Needs to look like this 2:07 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting total minutes into hours and minutes in Excel
You're welcome!
Biff "Colette" wrote in message ... Thank you so much. It works. "T. Valko" wrote: Try one of these: To convert the values in place: Enter 1440 in some empty cell Now, copy that cell, Goto EditCopy Select the values to convert Goto EditPaste SpecialDivideOK Format the cells as [h]:mm Or: A1 = 127 =A1/1440 Format as [h]:mm Biff "Colette" wrote in message ... I have a project which only gives me minutes. I need to convert the total minutes to hours and minutes. Example: 127 is the number (total minutes). I need it to read it took 2 hours and 7 minutes to complete. Needs to look like this 2:07 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting total minutes into hours and minutes in Excel
On 22 Dec 2006, 11:43, "David Biddulph"
wrote: No, Martin. Excel'stimes are in days, nothours. Colette will need to divide by 24, as well as by 60. Your formula will give 2:48 (having lost the odd 2 days), rather than 2:07. -- David Biddulph "Martin Fishlock" wrote in message ... If thehourswill be less than 24 then use 127/60 and format the cell as time using 24 hour clock. ... -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Colette" wrote: I have a project which only gives meminutes. I need to convert the total minutestohoursandminutes. Example: 127 is the number (total minutes). I need it to read it took 2hoursand 7minutesto complete. Needs to look like this 2:07- Hide quoted text - - Show quoted text - Genius! i found that very useful too! Cheers chetz |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting total minutes into hours and minutes in Excel
"Colette" wrote: I have a project which only gives me minutes. I need to convert the total minutes to hours and minutes. Example: 127 is the number (total minutes). I need it to read it took 2 hours and 7 minutes to complete. Needs to look like this 2:07 |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting total minutes into hours and minutes in Excel
"Colette" wrote: I have a project which only gives me minutes. I need to convert the total minutes to hours and minutes. Example: 127 is the number (total minutes). I need it to read it took 2 hours and 7 minutes to complete. Needs to look like this 2:07 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert total minutes to hours and minutes | Excel Discussion (Misc queries) | |||
converting Days Hours & minutes into just minutes in excel | 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) | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
Sum minutes and seconds to total hours | Excel Discussion (Misc queries) |