https://bz.apache.org/ooo/show_bug.cgi?id=127850
Peter <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] Resolution|--- |NOT_AN_OOO_ISSUE Status|UNCONFIRMED |RESOLVED --- Comment #1 from Peter <[email protected]> --- Aß dritten in Mail it is all a missunderstanding.if it helps Herr is the explanation again. If Three See questions Please send a Mail to Users Le dev Mailing List. This accounts for cases where the end time (H4) has a smaller clock value (e.g. 07:00) than the start time (e.g. 19:00) but is in the next day. Times are stored in units of days. The time 07:00 has the value 7/24 and the time 19:00 has the value 19/24. You were subtracting 7/24 - 19/24 = -12/24 = -0.5 If a cell is formatted as time, -0.5 is displayed as12:00, but the value is still -0.5. I appended + (G4 > H4) which returns FALSE (equal to zero) when H4 is larger than or equal to G4. When G4 is larger than H4, it returns TRUE (equal to one) that gives H4-G4 + (G4 >H4) = 7/24 - 19/24 + (19/24 > 7/24) = -0.5 + (TRUE) = -0.5 + 1 = 0.5 The 0.5, when formatted as time, is 12:00 and it is the desired answer. This is not a bug. All spreadsheets treat times as fractions of a day. Closing AS mit an issue. -- You are receiving this mail because: You are the assignee for the issue.
