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 |
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 |