Created attachment 110845 [details]
before and after sheet
Open up before.ods, select A2:K10, data/sort on column E asc, columnd D asc.
Check the formulas in column K, the same-row formulas refer now to different rows.
K10 has: =(H9+IF(D9>F9,1,0))*24
K6 has: =(H10+IF(D10>F10,1,0))*24
I think this is a duplicate of bug 81633. Version LO 4.2.8 should solve this.
Please set again to unconfirmed if LO 4.2.8 doesn't solve your issue
*** This bug has been marked as a duplicate of bug 81633 ***