Convert Hrs:Min to Decimal Hrs

I need to convert eg. 145:45 to decimal Hrs. (145.75) the Hrs. in the cells
are captured from another system that I have no control over.

Thanks in advance
DaveJhelpexcel

Try this, Dave: =C22*24
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"DaveJhelpexcel" <DaveJhelpexcel@discussions.microsoft.com> wrote in message
news:C5C4A7AB-245C-41EF-BE2D-82522EA37A7B@microsoft.com...
> I need to convert eg. 145:45 to decimal Hrs. (145.75) the Hrs. in the
cells
> are captured from another system that I have no control over.
>
> Thanks in advance
> DaveJhelpexcel

Thanks Anne,
But the hours part is already correct it's the colon and minutes that are
the problem.

"Anne Troy" wrote:

> Try this, Dave: =C22*24
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "DaveJhelpexcel" <DaveJhelpexcel@discussions.microsoft.com> wrote in message
> news:C5C4A7AB-245C-41EF-BE2D-82522EA37A7B@microsoft.com...
> > I need to convert eg. 145:45 to decimal Hrs. (145.75) the Hrs. in the
> cells
> > are captured from another system that I have no control over.
> >
> > Thanks in advance
> > DaveJhelpexcel
>
>
>

When you use Anne's solution you must format the cell as a number with 2
decimal places. Try it, it works.

-- Carlos

"DaveJhelpexcel" <DaveJhelpexcel@discussions.microsoft.com> wrote in message
news:5D3AF66D-7A6C-4743-B00B-F65FB724DACA@microsoft.com...
> Thanks Anne,
> But the hours part is already correct it's the colon and minutes that are
> the problem.
>
> "Anne Troy" wrote:
>
> > Try this, Dave: =C22*24
> > *******************
> > ~Anne Troy
> >
> > www.OfficeArticles.com
> > www.MyExpertsOnline.com
> >
> >
> > "DaveJhelpexcel" <DaveJhelpexcel@discussions.microsoft.com> wrote in
message
> > news:C5C4A7AB-245C-41EF-BE2D-82522EA37A7B@microsoft.com...
> > > I need to convert eg. 145:45 to decimal Hrs. (145.75) the Hrs. in the
> > cells
> > > are captured from another system that I have no control over.
> > >
> > > Thanks in advance
> > > DaveJhelpexcel
> >
> >
> >