hh:mm to decimal

[martyp]

Hi I need to convert an hh:mm to hh:mm in decimal?

Please can someone help?

many thanks

 

[Richard Schollar]

Hi Marty

Assuming time in A1, then what value would you expect to result from 13:45?

If 13.75:

=A1*24

If 0.572 then just format the time cell as 0.000

 

[VoG]

Try

=A1*24

and format the result cell as Number.

 

[martyp]

Sorry, silly mistake. I had the cell format as hh:mm rather than number.

Many thanks all.