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 containing two times


8:45 and 9:45

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

for these times the answer I need is 0.25 not 0.15. i.e. a quarter of
an hour

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=399414

See response in other group.

--

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 containing two times


8:45 and 9:45

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

for these times the answer I need is 0.25 not 0.15. i.e. a quarter of
an hour

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=399414

which thread in what group.


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

I assumed that you knew where you posting all these questions.

It was 'Difficult time question' in worksheet.functions.

You should probably read http://www.cpearson.com/excel/newposte.htm so as to
help us help you.


--

HTH

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


"bcbjork" wrote in
message ...

which thread in what group.


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

When I deleted my original thread there was no reply. I deleted the
original so that there would not be a duplicate of my question.

And as for the user guide. Which of the 35 points do you suggest my
thread does not satisfy. I have found one...I didn't specify that I was
using Word 2000.


Help us to help you:

I this five word response your idea of help?

-"See response in other group."-


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

I posted to the other thread, and decline to get into a slanging match with
you, so I will leave you to work it out for yourself in peace.


"bcbjork" wrote in
message ...

When I deleted my original thread there was no reply. I deleted the
original so that there would not be a duplicate of my question.

And as for the user guide. Which of the 35 points do you suggest my
thread does not satisfy. I have found one...I didn't specify that I was
using Word 2000.


Help us to help you:

I this five word response your idea of help?

-"See response in other group."-


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

=if(a11,if(b11,j11-i11,""),"")

=(a11-int(a11))*24


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