Just change the formula to

=H2-F2+(F2>=H2)-J2/24


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Joco" <Joco@discussions.microsoft.com> wrote in message
news:E027C5AD-93EE-4FAD-BAEE-6E36C0A091E7@microsoft.com...
> Bob Hi
>
> Thanks for your reply, it's so simple when you know how.
>
> In order to make your formula do what I want I have change your +J2/24 to
> -J2/24
> There is one cell where the answer to the formula is XXXXX this has been
> caused be cell lands up with a negative time which is not permissable.
>
> The cause of the error is because the take of time (F) and the landing
time
> (H) are identical ie 09:40 and 09:40 due to a refueling stop. If you know
a
> fix for this great, if not dont worry I have reduced the second time (H)
to
> 09:39 and it cures the problem
>
> I only have only mentioned the above so you are aware of it.
>
> Once again many thanks for the great formula.
>
> Regards Joco
>