| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting hours over 24 into decimal format
or number per Pete's reply.
"Toppers" wrote: format A2 as GENERAL "Ary" wrote: I don't think I understand. When I do this, I get a completely different time: A1 A2 =A1*24 126:47:59 19:11:36 I need it to read 126:47:59 and give me 126.7997 -- -Ary "Pete_UK" wrote: If you want them in decimal format then multiply by 24: =A1*24 and format the cell as number with appropriate decimal places. If you want to see them in time format, then click Format | Cells | Custom and enter [hh]:mm:ss in the panel then click OK. Hope this helps. Pete On Jul 4, 11:42 am, Ary wrote: How would I convert hours such as 128:24:12 to 128.403? In previous discussions, I saw someone suggest formatting the cell as [hh]:mm, but I have no idea what this means nor how to do it. -- -Ary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Hours to Decimal | Excel Discussion (Misc queries) | |||
| Converting a decimal time into hours and minutes | Excel Worksheet Functions | |||
| converting a decimal number to hours and seconds | Excel Worksheet Functions | |||
| Converting decimal calculation to h:mm format | Excel Worksheet Functions | |||
| Format a cell to display decimal hours. | Excel Discussion (Misc queries) | |||
Hybrid Mode
