Prev: Lose the 0 in the Total cell
Next: Can't rework the formula
From: Gord Dibben on 31 May 2010 18:07
Yes.

After seeing Biff's reply I realized there is an easier and more accurate
method.

Your suggestion is basically same as his. although as written, your formula
return an error due to the extra " after mm

My final try.............

=INT(A2-A1)&" days "&TEXT(MOD(A2-A1,1),"hh "" hours ""mm"" minutes""")



Gord


On Mon, 31 May 2010 20:28:20 +0100, "David Biddulph" <groups [at]
biddulph.org.uk> wrote:

>Doesn't that formula go wrong if the time in A1 is earlier than the time in
>A2, Gord?
>
>Isn't it easier not to use DATEDIF, and just to use
> =INT(A2-A1) & " days "&TEXT(MOD(A2-A1,1),"hh "" hours ""mm"" ?

From: Raj on 1 Jun 2010 07:58
Thanks to All; these were the insights I was looking for.

Regards.
Raj


On Jun 1, 3:07 am, Gord Dibben <gorddibbATshawDOTca> wrote:
> Yes.
>
> After seeing Biff's reply I realized there is an easier and more accurate
> method.
>
> Your suggestion is basically same as his. although as written, your formula
> return an error due to the extra "  after mm
>
> My final try.............
>
> =INT(A2-A1)&" days "&TEXT(MOD(A2-A1,1),"hh "" hours ""mm"" minutes""")
>
> Gord
>
> On Mon, 31 May 2010 20:28:20 +0100, "David Biddulph" <groups [at]
>
> biddulph.org.uk> wrote:
> >Doesn't that formula go wrong if the time in A1 is earlier than the time in
> >A2, Gord?
>
> >Isn't it easier not to use DATEDIF, and just to use
> > =INT(A2-A1) & " days "&TEXT(MOD(A2-A1,1),"hh "" hours ""mm"" ?

First  |  Prev  | 
Pages: 1 2
Prev: Lose the 0 in the Total cell
Next: Can't rework the formula