(A1-B1)*24
format as general

Mangesh




"bcbjork" wrote in
message ...

This is my first post so hello everyone and thankyou in advance for any
assistance you can provide.

The diffuclty I am having is as follows:

I have a spreadsheet with two times


8:45 9:45

I need to find the difference in the two times as a decimal but as a
fraction of an hour..

for thesee times the answer I need is 0.25 not 0.15.

Can anyone help?


--
bcbjork
------------------------------------------------------------------------
bcbjork's Profile:
http://www.excelforum.com/member.php...o&userid=26665
View this thread: http://www.excelforum.com/showthread...hreadid=399403