Help me solve this calculation

[Sutemi]

Fields D17, D18, D19 and D20 have the times of departure arranged in
chronological order (i.e. D17=12.00, D18=13.30, D19=14.45 and D20 is blank).

Fields E17, E18, E19 and D20 have the times of arrival arranged in
chronological order (i.e. E17=13.00, E18=14.00, E19=15.00 and E20 is blank).

The idea is to use F17 to calculate the difference between the first time of
departure (which is always D17) and the LAST given time of arrival (E17
through E20). I've fought with this for hours but i can't make it work. Any
help?

Hi
Try something like this:
=MAX(E17:E20)-D17

--
Andy.


"Sutemi" <Sutemi@discussions.microsoft.com> wrote in message
news:87F89F17-89EA-4D06-986F-5791FA8458A7@microsoft.com...
> Fields D17, D18, D19 and D20 have the times of departure arranged in
> chronological order (i.e. D17=12.00, D18=13.30, D19=14.45 and D20 is
> blank).
>
> Fields E17, E18, E19 and D20 have the times of arrival arranged in
> chronological order (i.e. E17=13.00, E18=14.00, E19=15.00 and E20 is
> blank).
>
> The idea is to use F17 to calculate the difference between the first time
> of
> departure (which is always D17) and the LAST given time of arrival (E17
> through E20). I've fought with this for hours but i can't make it work.
> Any
> help?

[Sutemi]

Hey that works! Damn, i tried EXTREMELY complex mathematical formulas and the
answer was THIS simple!

*bangs his head on the wall*

Anyway, millions of thanks to you Andy B!





"Andy B" kirjoitti:

> Hi
> Try something like this:
> =MAX(E17:E20)-D17
>
> --
> Andy.
>
>
> "Sutemi" <Sutemi@discussions.microsoft.com> wrote in message
> news:87F89F17-89EA-4D06-986F-5791FA8458A7@microsoft.com...
> > Fields D17, D18, D19 and D20 have the times of departure arranged in
> > chronological order (i.e. D17=12.00, D18=13.30, D19=14.45 and D20 is
> > blank).
> >
> > Fields E17, E18, E19 and D20 have the times of arrival arranged in
> > chronological order (i.e. E17=13.00, E18=14.00, E19=15.00 and E20 is
> > blank).
> >
> > The idea is to use F17 to calculate the difference between the first time
> > of
> > departure (which is always D17) and the LAST given time of arrival (E17
> > through E20). I've fought with this for hours but i can't make it work.
> > Any
> > help?
>
>
>

Glad to help and thanks for the feedback!

--
Andy.


"Sutemi" <Sutemi@discussions.microsoft.com> wrote in message
news:9369D34D-37B7-4300-B888-3F1F296DC08B@microsoft.com...
> Hey that works! Damn, i tried EXTREMELY complex mathematical formulas and
> the
> answer was THIS simple!
>
> *bangs his head on the wall*
>
> Anyway, millions of thanks to you Andy B!
>
>
>
>
>
> "Andy B" kirjoitti:
>
>> Hi
>> Try something like this:
>> =MAX(E17:E20)-D17
>>
>> --
>> Andy.
>>
>>
>> "Sutemi" <Sutemi@discussions.microsoft.com> wrote in message
>> news:87F89F17-89EA-4D06-986F-5791FA8458A7@microsoft.com...
>> > Fields D17, D18, D19 and D20 have the times of departure arranged in
>> > chronological order (i.e. D17=12.00, D18=13.30, D19=14.45 and D20 is
>> > blank).
>> >
>> > Fields E17, E18, E19 and D20 have the times of arrival arranged in
>> > chronological order (i.e. E17=13.00, E18=14.00, E19=15.00 and E20 is
>> > blank).
>> >
>> > The idea is to use F17 to calculate the difference between the first
>> > time
>> > of
>> > departure (which is always D17) and the LAST given time of arrival (E17
>> > through E20). I've fought with this for hours but i can't make it work.
>> > Any
>> > help?
>>
>>
>>