Convert Time format to decimal format

[2Plan]

Does anyone know how to convert Time format to decimal format?

Is there an easy to convert 42h51 to 42.85?

 

[2Plan]

Is there an easy to convert 42h51 to 42.85 using MS Excel?

 

[strongm]

If you have 42:51 in 1 then make any other cell =A1*24

 

[strongm]

or, if you haven't got it in a cell, then:

=TIMEVALUE("42:51")*24

 

[SkipVought]

FYI:

faq68-5827

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}