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

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 <A...@discussions.microsoft.com> 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

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

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

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 <A...@discussions.microsoft.com> 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
>
>
>

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 <A...@discussions.microsoft.com> 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
> >
> >
> >

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 <A...@discussions.microsoft.com> 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
> > >
> > >
> > >