Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 4th 07, 11:42 AM posted to microsoft.public.excel.worksheet.functions
Ary Ary is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2
Default 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   Report Post  
Old July 4th 07, 11:48 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default 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   Report Post  
Old July 4th 07, 11:56 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 11,501
Default 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   Report Post  
Old July 4th 07, 11:56 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,339
Default 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   Report Post  
Old July 4th 07, 12:10 PM posted to microsoft.public.excel.worksheet.functions
Ary Ary is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2
Default 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   Report Post  
Old July 4th 07, 12:26 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,339
Default 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   Report Post  
Old July 4th 07, 12:34 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,339
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 09:35 AM
Converting decimal calculation to h:mm format Gina A. Excel Worksheet Functions 3 November 16th 05 11:27 PM
Format a cell to display decimal hours. Fred Holmes Excel Discussion (Misc queries) 2 March 18th 05 03:32 PM


All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017