https://bugs.documentfoundation.org/show_bug.cgi?id=97031
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |rg --- Comment #2 from m.a.riosv <[email protected]> --- Created attachment 121842 --> https://bugs.documentfoundation.org/attachment.cgi?id=121842&action=edit Sample file modified with a way to solve. I think not such issue. Please take a look: https://help.libreoffice.org/5.0/Calc/Date_and_Time_Functions https://help.libreoffice.org/index.php?title=5.0/Common/Numbers_Format&Language=en-US&System=WIN&Version=5.0#bm_id3153312 In your sample time#2 have not taking in account if they are before or after time#1. time format shows always positives values, so for negatives it shows the complementary. I think in attached file you can find what is happen an a way to solve it, using right values for the average. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
