Creating a formula for time

[RMC1213]

What I need done is to change time. Example I need to be able to change hours into a whole number. 1 hour and a half. into 1.5. That is the best I can explain this.

 

[Mark W.]

Care to provide an example?

 

[Al Chara]

1.5 isn't a whole number. Are trying to covert the text "1 hour and a half" into 1.5 or 1:30 into 1.5? Be more specific...

 

[RMC1213]

SORRY ABOUT NOT BEING CLEARER. I WANT 1:30 = 1.5 IS THAT HELPFUL.

 

[Mark W.]

On 2002-04-17 09:54, RMC1213 wrote:
SORRY ABOUT NOT BEING CLEARER. I WANT 1:30 = 1.5 IS THAT HELPFUL.

If A1 contains 1:30 then...

=A1*24 produces 1.5 when formatted as General
This message was edited by Mark W. on 2002-04-17 09:56

 

[RMC1213]

Thank You sooooo..very much.