Time to decimal

imonline · Apr 17th, 2002, 09:21 AM

I've got a cell that shows me the time spent on a certAIN MACHINE (02:25:12), which shows hours:minutes:seconds

How do I set this cell, without using a macro, to show me a decimal value (2.42 hours). I've tried all the cell formats on Excel.

Don L.

Dave Patton · Apr 17th, 2002, 09:26 AM

with time in A2,

=A2*24

Format the result as number

Mark W. · Apr 17th, 2002, 09:28 AM

Quote:

On 2002-04-17 08:21, imonline wrote:
I've got a cell that shows me the time spent on a certAIN MACHINE (02:25:12), which shows hours:minutes:seconds

How do I set this cell, without using a macro, to show me a decimal value (2.42 hours). I've tried all the cell formats on Excel.

Don L.

Don, this can't be done with formatting. You could enter a formula in another cell that converts your time value (in cell A1) to hours...

=A1*24

imonline · Apr 17th, 2002, 10:37 AM

Thanks!!! Dave and Mark

The formula worked great, i know it seemed simple but I was racking my brain to find out how.

Again thanks,

Don L.

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

Apr 17th, 2002, 09:21 AM	#1
imonline New Member Join Date: Apr 2002 Location: St Leonard, New Brunswick, Canada Posts: 9	I've got a cell that shows me the time spent on a certAIN MACHINE (02:25:12), which shows hours:minutes:seconds How do I set this cell, without using a macro, to show me a decimal value (2.42 hours). I've tried all the cell formats on Excel. Don L.

Apr 17th, 2002, 09:26 AM	#2
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	with time in A2, =A2*24 Format the result as number

Apr 17th, 2002, 10:37 AM	#4
imonline New Member Join Date: Apr 2002 Location: St Leonard, New Brunswick, Canada Posts: 9	Thanks!!! Dave and Mark The formula worked great, i know it seemed simple but I was racking my brain to find out how. Again thanks, Don L.