Format decimal to specific type of format

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??

Not clear if you want B2 to be 24.15 or 24:15 format as 24.15 - the two are very different values.

For 24.15 as Decimal

Please Login or Register  to view this content.

(DOLLARFR requires activation of Analysis ToolPak pre XL2007)

or

Please Login or Register  to view this content.

If you want B2 as hours but format as though decimal then:

Please Login or Register  to view this content.

One option:

Please Login or Register  to view this content.

assumes A2 not 0

Thank you very much DonckeyOte, you are a master.Do you mind writing the formula for the reverse option please? So I can allow the user if they only have the time e.g
D2= 5.30 (time)
E2= 5.50 (decimal) including negative values

Currently I am using

Please Login or Register  to view this content.

which doesnt allow negative time.

If it is too much trouble not to worry.

Many Thanks

To work in reverse:

Please Login or Register  to view this content.

(above assumes A2 not 0 obviously)