Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Minutes to Hours:minutes
Hi,
I've been looking, with no success to some post and could not find the answer. I am sure this has been answered in the past so sorry to ask again. I have a result in minutes:320 for example I would like to have the result displayed as 5:20 and not 5.33 (cell/60). Also, if the number of minutes is greater than 1440 (day) I would like to have the 2 options: - hh:mn - d:hh:mn In fact I am using both format in 2 reports. Thanks in advance if you have the solution. Regards Fred |
#2
|
|||
|
|||
Fred,
Divide by 1440 and format as time =A1/1440 -- HTH RP (remove nothere from the email address if mailing direct) "fredmunich" wrote in message ... Hi, I've been looking, with no success to some post and could not find the answer. I am sure this has been answered in the past so sorry to ask again. I have a result in minutes:320 for example I would like to have the result displayed as 5:20 and not 5.33 (cell/60). Also, if the number of minutes is greater than 1440 (day) I would like to have the 2 options: - hh:mn - d:hh:mn In fact I am using both format in 2 reports. Thanks in advance if you have the solution. Regards Fred |
#3
|
|||
|
|||
Thanks Bob,
This resolve my problem if the number of minutes is below 1440. If the number of minutes is more than 1440 excel forget the remaining hours. So if I format the cell with dd:hh:mn it works fine for my first request. But for my second request (format hours:mn it does not work. I'd like to be able to show for exemple 278 h and 23 mn. Do you have an idea for this? "Bob Phillips" wrote: Fred, Divide by 1440 and format as time =A1/1440 -- HTH RP (remove nothere from the email address if mailing direct) "fredmunich" wrote in message ... Hi, I've been looking, with no success to some post and could not find the answer. I am sure this has been answered in the past so sorry to ask again. I have a result in minutes:320 for example I would like to have the result displayed as 5:20 and not 5.33 (cell/60). Also, if the number of minutes is greater than 1440 (day) I would like to have the 2 options: - hh:mn - d:hh:mn In fact I am using both format in 2 reports. Thanks in advance if you have the solution. Regards Fred |
#4
|
|||
|
|||
I've found the solution.
For case 1, Bob give me the answer.A1/1440 But For case 2 (when hours 24) and case 1 the format of the cell must be [h]:mn and not hh:mn or even dd:hh:mn Thanks again "fred" wrote: Thanks Bob, This resolve my problem if the number of minutes is below 1440. If the number of minutes is more than 1440 excel forget the remaining hours. So if I format the cell with dd:hh:mn it works fine for my first request. But for my second request (format hours:mn it does not work. I'd like to be able to show for exemple 278 h and 23 mn. Do you have an idea for this? "Bob Phillips" wrote: Fred, Divide by 1440 and format as time =A1/1440 -- HTH RP (remove nothere from the email address if mailing direct) "fredmunich" wrote in message ... Hi, I've been looking, with no success to some post and could not find the answer. I am sure this has been answered in the past so sorry to ask again. I have a result in minutes:320 for example I would like to have the result displayed as 5:20 and not 5.33 (cell/60). Also, if the number of minutes is greater than 1440 (day) I would like to have the 2 options: - hh:mn - d:hh:mn In fact I am using both format in 2 reports. Thanks in advance if you have the solution. Regards Fred |
#5
|
|||
|
|||
Not if you format the cell as [h]:mm:ss, note the [ ]
-- HTH RP (remove nothere from the email address if mailing direct) "fred" wrote in message ... Thanks Bob, This resolve my problem if the number of minutes is below 1440. If the number of minutes is more than 1440 excel forget the remaining hours. So if I format the cell with dd:hh:mn it works fine for my first request. But for my second request (format hours:mn it does not work. I'd like to be able to show for exemple 278 h and 23 mn. Do you have an idea for this? "Bob Phillips" wrote: Fred, Divide by 1440 and format as time =A1/1440 -- HTH RP (remove nothere from the email address if mailing direct) "fredmunich" wrote in message ... Hi, I've been looking, with no success to some post and could not find the answer. I am sure this has been answered in the past so sorry to ask again. I have a result in minutes:320 for example I would like to have the result displayed as 5:20 and not 5.33 (cell/60). Also, if the number of minutes is greater than 1440 (day) I would like to have the 2 options: - hh:mn - d:hh:mn In fact I am using both format in 2 reports. Thanks in advance if you have the solution. Regards Fred |
#6
|
|||
|
|||
Thanks Bob.
This was the good trick. Thanks for your support "Bob Phillips" wrote: Not if you format the cell as [h]:mm:ss, note the [ ] -- HTH RP (remove nothere from the email address if mailing direct) "fred" wrote in message ... Thanks Bob, This resolve my problem if the number of minutes is below 1440. If the number of minutes is more than 1440 excel forget the remaining hours. So if I format the cell with dd:hh:mn it works fine for my first request. But for my second request (format hours:mn it does not work. I'd like to be able to show for exemple 278 h and 23 mn. Do you have an idea for this? "Bob Phillips" wrote: Fred, Divide by 1440 and format as time =A1/1440 -- HTH RP (remove nothere from the email address if mailing direct) "fredmunich" wrote in message ... Hi, I've been looking, with no success to some post and could not find the answer. I am sure this has been answered in the past so sorry to ask again. I have a result in minutes:320 for example I would like to have the result displayed as 5:20 and not 5.33 (cell/60). Also, if the number of minutes is greater than 1440 (day) I would like to have the 2 options: - hh:mn - d:hh:mn In fact I am using both format in 2 reports. Thanks in advance if you have the solution. Regards Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
Adding minutes to time | Excel Discussion (Misc queries) | |||
convert minutes into hours:minutes | Excel Worksheet Functions | |||
How do I convert minutes to hours:minutes? | Excel Worksheet Functions |