Decimal to Time Format.

[GEM]

What function can I use to convert a decimal number to a time number?? For
example,

The decimal number "1.50" would mean 1 HOUR 30 MINUTES.

1.25 would mean 1 HOUR 15 MINUTES.

Is there a formula for this operation??

 

[David Biddulph]

Divide by 24 and format as time.

 

[GEM]

Thank you!!! Is there a way to inverse this?? Ex. Type 1:30 in one cell and
get 1.50 in another cell?

 

[Lars-Åke Aspelin]

Multiply by 24 and format as number

Lars-Åke

Thank you!!! Is there a way to inverse this?? Ex. Type 1:30 in one cell and
get 1.50 in another cell?

 

[Dave Peterson]

Multiply by 24 and format as General (or number).

Thank you!!! Is there a way to inverse this?? Ex. Type 1:30 in one cell and
get 1.50 in another cell?

 

[Peo Sjoblom]

A1 holds the time value 1:30
in B2

=TEXT(A1*24,"0.00")

or if you need it to be a number format B2 as number with 2 decimals




--


Regards,


Peo Sjoblom

 

[GEM]

Thanks to all!!!!

A1 holds the time value 1:30
in B2

=TEXT(A1*24,"0.00")

or if you need it to be a number format B2 as number with 2 decimals




--


Regards,


Peo Sjoblom