How do I convert time (38:30) to decimal (38.5) format?

How do I convert time (38:30) to decimal (38.5) format?

In a cell that's formated as number, 2 decimals, put: =B1*24
Where B1 contains your 38:30.
************
Anne Troy
www.OfficeArticles.com

"Lori" <[email protected]> wrote in message
news:[email protected]...
> How do I convert time (38:30) to decimal (38.5) format?

Multiply with 24 AND format as general or number

--
Regards,

Peo Sjoblom

(No private emails please)


"Lori" <[email protected]> wrote in message
news:[email protected]...
> How do I convert time (38:30) to decimal (38.5) format?

Thank You!

"Anne Troy" wrote:

> In a cell that's formated as number, 2 decimals, put: =B1*24
> Where B1 contains your 38:30.
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "Lori" <[email protected]> wrote in message
> news:[email protected]...
> > How do I convert time (38:30) to decimal (38.5) format?
>
>
>

Welcome!
************
Anne Troy
www.OfficeArticles.com

"Lori" <[email protected]> wrote in message
news:[email protected]...
> Thank You!
>
> "Anne Troy" wrote:
>
>> In a cell that's formated as number, 2 decimals, put: =B1*24
>> Where B1 contains your 38:30.
>> ************
>> Anne Troy
>> www.OfficeArticles.com
>>
>> "Lori" <[email protected]> wrote in message
>> news:[email protected]...
>> > How do I convert time (38:30) to decimal (38.5) format?
>>
>>
>>