Decimal to Time Format.
 

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

Decimal to Time Format.
 

Divide by 24 and format as time.
--
David Biddulph

"GEM" wrote in message
...
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??

Decimal to Time Format.
 

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


"David Biddulph" wrote:

Divide by 24 and format as time.
--
David Biddulph

"GEM" wrote in message
...
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??

Decimal to Time Format.
 

Multiply by 24 and format as number

Lars-Åke

On Wed, 30 Jul 2008 14:36:01 -0700, GEM
wrote:

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


"David Biddulph" wrote:

Divide by 24 and format as time.
--
David Biddulph

"GEM" wrote in message
...
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??

Decimal to Time Format.
 

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

GEM wrote:

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

"David Biddulph" wrote:

Divide by 24 and format as time.
--
David Biddulph

"GEM" wrote in message
...
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??




--

Dave Peterson

Decimal to Time Format.
 

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" wrote in message
...
Thank you!!! Is there a way to inverse this?? Ex. Type 1:30 in one cell
and
get 1.50 in another cell?


"David Biddulph" wrote:

Divide by 24 and format as time.
--
David Biddulph

"GEM" wrote in message
...
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??

Decimal to Time Format.
 

Thanks to all!!!!

"Peo Sjoblom" wrote:

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" wrote in message
...
Thank you!!! Is there a way to inverse this?? Ex. Type 1:30 in one cell
and
get 1.50 in another cell?


"David Biddulph" wrote:

Divide by 24 and format as time.
--
David Biddulph

"GEM" wrote in message
...
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??