Creating a formula for time

RMC1213 · Apr 17th, 2002, 10:40 AM

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. · Apr 17th, 2002, 10:44 AM

Care to provide an example?

Al Chara · Apr 17th, 2002, 10:47 AM

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 · Apr 17th, 2002, 10:54 AM

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

Mark W. · Apr 17th, 2002, 10:56 AM

Quote:

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 · Apr 17th, 2002, 10:58 AM

Thank You sooooo..very much.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 10:40 AM	#1
RMC1213 New Member Join Date: Apr 2002 Posts: 3	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.

Apr 17th, 2002, 10:44 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Care to provide an example?

Apr 17th, 2002, 10:47 AM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	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...

Apr 17th, 2002, 10:54 AM	#4
RMC1213 New Member Join Date: Apr 2002 Posts: 3	SORRY ABOUT NOT BEING CLEARER. I WANT 1:30 = 1.5 IS THAT HELPFUL.

Apr 17th, 2002, 10:58 AM	#6
RMC1213 New Member Join Date: Apr 2002 Posts: 3	Thank You sooooo..very much.