? with subtracting time..

[lherndo]

I want to take a cell with 11:00 o'clock in it and subtract a cell with 9:30 o'clock in it. If I format the cell value with time it gives me 1:30 wich is correct. But I want it to show me the hours in decimal form i.e. 1.5 hours. How do I do this?

[Domenic]

Try...

=(A1-B1)*24

...and format as 'General'.

Hope this helps!

[neopolitan]

Check out the Chip Pearson site. Look in his Index under "T".

http://www.cpearson.com/excel/topic.htm