Hi
My worksheet (part of a workbook) records the amount of time spent flying,
relevant columns are shown below, items in () are how the cells are currently
formatted

B date (ddd dd-mmm-yyyy)
F take off time (hh:mm)
H landing time (hh:mm)
J BST or GMT difference +/- as a positive, minus not allowed (hh:mm)
K Flying hours after adjusting for J (dd:hh:mm) must be able to total this
column

Often the landing time goes into the next day, for which currently no date
is shown

I have tried all sorts of formulas, and are unable tofind a universal
formula to fit all options, and are now totally confused

Help would be greatly appreciated

Thanks Joco