OT: Excel Help Please

[MikeVic]

I want to find the elapsed time between two times.. so, say we have 18:00 in cell A1, and 9:30 in cell B1.. when I do "=A1-B1," I get 0.35.. so I changed it to Time format also, and I get 8:30. I want it to say 8.5, for 8 and a half hours. Or if the result is 8:45, for it to say 8.75... is there any way to do this?

Thanks.

[TredWel]

Change the format back to a number, and use the following formula: =(A1-B1)*24

[Huckleberry]

Set C1=(A1-B1)*24

Set C1 to display as a number with 2 decimal places.

edit - That's what I get for paying attention to work for a few minutes after opening this thread. ;)

[MikeVic]

Thanks TredWel. And thank you Huckleberry as well. ;)