| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
decimals as hours change to minutes
In this ss I am calculating hours. Hours are expressed as 7.5 hours etc. Is
there a way to express this as hours and minutes instead of the decimal. 7 hours 30 minutes. I must mention that I am adding up several cells to get the results. The cells that I am adding are represented the same way. I would like to change them into hours and minutes instead of the decimal. Thanks in advance Scott |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
decimals as hours change to minutes
=A1/24
format cell as h:mm "scott" wrote: In this ss I am calculating hours. Hours are expressed as 7.5 hours etc. Is there a way to express this as hours and minutes instead of the decimal. 7 hours 30 minutes. I must mention that I am adding up several cells to get the results. The cells that I am adding are represented the same way. I would like to change them into hours and minutes instead of the decimal. Thanks in advance Scott |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change minutes to hours and minutes | 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 | |||
Linear Mode
