Difference in Times

**bcbjork** · 08-26-2005, 06:47 AM

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?

Bob Phillips · 08-26-2005, 08:05 AM

See response in other group.

--

HTH

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

"bcbjork" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

**bcbjork** · 08-26-2005, 08:35 AM

Thanks for taking the time to answer my question. Although your response is about as helpful as a walkie talkie to a deaf police officer.

This surely must be a BASIC problem to you but you can;t afford the time to construct even a brief answer.

I have eyes, do you not think I would have read all the relevant threads and posts before asking my question. Do you not think I performed a search for key words. What would you say if you came in to see me with a medical problem and I told you to see another doctor because he has already told someone else the answer to your question.

The thread you refer to does not answer my question. Although I cannot be entirely sure that I refer to the same thread as you because you didn't even take the time to copy a shortcut to the thread you mean or even copy the text from within.

I guess what I am trying to say is......the world would be a better place without lazy, unhelpful and arrogant people like you.

Bob Phillips · 08-26-2005, 10:05 AM

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

**bcbjork** · 08-26-2005, 11:05 AM

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:

Is this five word response your idea of help?

"See response in other group."

Bob Phillips · 08-26-2005, 01:05 PM

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>