Joco,

I would use the GMT/BST offset to be input in decimal hours, and then use

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

in K2

When adding, ensure the results cell is formatted as [h]:mm

--
HTH

Bob Phillips

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

"Joco" wrote in message
...
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