Re: time subtraction problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

You can also copy Bob's formula down the column. It will work with both
cases.

--
Regards
Roger Govier
<a> wrote in message news:42d770d3$1@xxxxxxxxxxxxxxxxxxxxxx
> thanks.
>
> both formulae worked,
> but I would prefer the IF statement even though its abit longer.
> since it applies to both cases of A1 > B1 or B1 > A1, i can drag the
> formula down the whole column.
>
> BTW, what does (time + 1) do to the smaller time?
>
> thnks.


.

Relevant Pages

  • Re: CountIF function
    ... Regards ... Roger Govier ... > How does one get to arrange in numerical order How many times each number ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Date difference
    ... Regards ... Roger Govier ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Formula Check... Please
    ... Regards ... Roger Govier ... I didn't receive a response on my last post so I worked on my problem ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: "IF" Formulae
    ... Regards ... Roger Govier ... >>> My problem is that I can't override the first false conclusion. ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Counting Cells
    ... Regards ... Roger Govier ... Some days are missing and a blank has been left for those days (in ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)