Home 
Search 
Today's Posts 
#1




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




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




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




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




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




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




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) 