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.

 Converting hours over 24 into decimal format
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Converting hours over 24 into decimal format

#1
July 4th 07, 11:42 AM posted to microsoft.public.excel.worksheet.functions
 Ary external usenet poster 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
 Pete_UK external usenet poster 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
 Mike H external usenet poster 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
 Toppers external usenet poster Posts: 4,340
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
 Ary external usenet poster 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
 Toppers external usenet poster Posts: 4,340
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
 Toppers external usenet poster Posts: 4,340
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
> > >
> > >
> > >

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 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:21 PM.