https://bugs.documentfoundation.org/show_bug.cgi?id=170658
Bug ID: 170658
Summary: Error calculating differences between dates
Product: LibreOffice
Version: 25.8.4.2 release
Hardware: ARM
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 205419
--> https://bugs.documentfoundation.org/attachment.cgi?id=205419&action=edit
Screenshot
Language: Spanish
In the spreadsheet, column A contains dates and times, and column C contains
the difference between them.
The formula in column C is =SI(A84>0;((A84<A83)+A84-A83);0)
as shown in the screenshot.
The format of column C is: D“d ”HH“h”.
If I am not mistaken, the cells in column C should be:
C84 4d 22h
C85 4d 17h
C86 2d 06h
In all of them, there is one day missing.
--
You are receiving this mail because:
You are the assignee for the bug.
