https://bz.apache.org/ooo/show_bug.cgi?id=119374
--- Comment #7 from mroe <[email protected]> --- What is the Excel way and the LibreOffice way? AOO do it right in my opinion. "Semantics: Returns the fraction of the day consumed by the given time" It simply returns the clock time at the resulting day. So any result will and must be in the range 0 (=00:00:00) <= result < 1 (=24:00:00). TIME(24;0;0) = 00:00:00 TIME(0;120;0) = 02:00:00 TIME(-1;120;0) = 01:00:00 (one hour before 120 minutes) If we allow all negative parameters then there must be TIME(-1:0;0) = 23:00:00 (one hour before 00:00:00) This is exactly the same what TIMEVALUE("-1:0:0") returns. TIME and TIMEVALUE should always give the same result as they do for all positive results at this time: TIMEVALUE("24:0:0") = 00:00:00 TIMEVALUE("0:120:0") = 02:00:00 TIMEVALUE("-1:120:0") = 01:00:00 (one hour before 120 minutes) My vote: 0 <= TIME(a;b;c) = TIMEVALUE("a:b:c") < 1 -- You are receiving this mail because: You are the assignee for the issue.
