This is it, well almost.
=(INT(SUM(D4
23))+INT(100*((D4-INT(D4))+(D6-INT(D6))+(D7-INT(D7))+(D8-INT(D8))+(D9-INT(D9))+(D10-INT(D10))+(D11-INT(D11 ))+(D12-INT(D12))+(D13-INT(D13))+(D14-INT(D14))+(D15-INT(D15))+(D16-INT(D16))+(D17-INT(D17))+(D18-INT(D18))+(D19-INT(D19 ))+(D20-INT(D20))+(D21-INT(D21))+(D22-INT(D22))+(D23-INT(D23)))/60)+(MOD(100*(D4-INT(D4)+(D6-INT(D6)+(D7-INT(D7)+(D8-INT (D8)+(D9-INT(D9)+(D10-INT(D10)+(D11-INT(D11)+(D12-INT(D12)+(D13-INT(D13)+(D14-INT(D14))+(D15-INT(D15))+(D16-INT(D16))+(D 17-INT(D17))+(D18-INT(D18))+(D19-INT(D19))+(D20-INT(D20))+(D21-INT(D21))+(D22-INT(D22))+(D23-INT(D23)))))))))));60)/100) )
That formula adds 20 flight legs in the format. ( hh . mm ), which would suit me fine. I am sure there is an easier way, still looking for it. There is only one problem with it, which I have not worked out yet. You can try for yourself and see what happens at ( D10 ), ( D15 ) and ( D20 ) using ( 1.20 ) for every step.
