Remember Me?

#1
July 4th 07, 11:42 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2007 Posts: 2
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
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
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
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
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
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
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
July 4th 07, 12:10 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2007 Posts: 2
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
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
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
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
Converting hours over 24 into decimal format

"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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Helen Excel Discussion (Misc queries) 7 May 24th 10 05:37 PM LizHough Excel Worksheet Functions 1 July 4th 06 11:00 AM jeda67 Excel Worksheet Functions 1 December 4th 05 10:35 AM Gina A. Excel Worksheet Functions 3 November 17th 05 12:27 AM Fred Holmes Excel Discussion (Misc queries) 2 March 18th 05 04:32 PM

All times are GMT +1. The time now is 12:41 AM.