Difficult Time equation
 

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

(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

Time is stored as a fraction of a day, so just multiply by 24 to get decimal
time.

In your case

=(B1-A1)*24

although I get 1, not .25

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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