Format decimal to specific type of format

[greekboyuk]

Hi there,

I am trying to convert a number which shows decimal time formatting to a time formatting however to be displayed again as decimal. e.g


Cell A2 = 24.25 (which is 24hours and 15minutes)
Cell B2 should be equal to 24.15 (which is 24 hours and 15minutes)

I tried to use the timevalue formula but is not displaying the format that I want and they all seem to stop after 24hours (displaying 0 values)


Can anyone help please??