Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying hours and minutes
How do I get excel to display results in hours and minutes, not as
time but as duration? For example in cell C2 I have 175 for 175 minutes. In cell D2 I have C2/60 to give 2.9166667 as the result in hours as a decimal. How do I get it to display that decimal in duration of time e.g. 2 hours 55 minutes? Cheers John |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying hours and minutes
John --
If your data cell is A1, then here's a formula that works: =INT(A1) & " hours and " & ROUND((MOD(A1,1)*60),0) & " minutes." HTH. "John" wrote: How do I get excel to display results in hours and minutes, not as time but as duration? For example in cell C2 I have 175 for 175 minutes. In cell D2 I have C2/60 to give 2.9166667 as the result in hours as a decimal. How do I get it to display that decimal in duration of time e.g. 2 hours 55 minutes? Cheers John |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying hours and minutes
=C2/60/24
format cell as h:mm "John" wrote: How do I get excel to display results in hours and minutes, not as time but as duration? For example in cell C2 I have 175 for 175 minutes. In cell D2 I have C2/60 to give 2.9166667 as the result in hours as a decimal. How do I get it to display that decimal in duration of time e.g. 2 hours 55 minutes? Cheers John |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying hours and minutes
Thanks guys! Both those methods work great.
John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
how to change a decimal number (minutes) into hours and minutes? | 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 |