If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#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 
Ads 
#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 > > > > > > > > > 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Converting Hours to Decimal  Helen  Excel Discussion (Misc queries)  7  May 24th 10 05:37 PM 
Converting a decimal time into hours and minutes  LizHough  Excel Worksheet Functions  1  July 4th 06 11:00 AM 
converting a decimal number to hours and seconds  jeda67  Excel Worksheet Functions  1  December 4th 05 10:35 AM 
Converting decimal calculation to h:mm format  Gina A.  Excel Worksheet Functions  3  November 17th 05 12:27 AM 
Format a cell to display decimal hours.  Fred Holmes  Excel Discussion (Misc queries)  2  March 18th 05 04:32 PM 