Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting hours over 24 into decimal format
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting hours over 24 into decimal format
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting hours over 24 into decimal format
Multiply time * 24
select your cell and then format:cells:custom and enter a format of [hh]:mm:ss Enter your time in that cell 18:22:13 (say cell A1) In b1 typr =A1*24 Change thje format to general and your done. Mike "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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting hours over 24 into decimal format
Multiply by 24 and format cell as General.
=A1*24 a1=128:24:12 (formatted as [h]:mm:ss) Format of [h]:mm:ss allows hours of 24 to be displayed. 128:24:12 with hh:mm:ss would be display as 8:24:12 [removing 120 (5*24 hours)]. "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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting hours over 24 into decimal format
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting hours over 24 into decimal format
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 |
#7
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) |