Bug 152902 - Time difference calculations
Summary: Time difference calculations
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.3.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-01-06 12:52 UTC by wm1961
Modified: 2023-01-06 13:09 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description wm1961 2023-01-06 12:52:33 UTC 
Description:
A1 = 2023-01-03 03:00:00
A2 = 2023-01-02 02:00:00
A3 = =A1-A2   display 31d 01g 00m     ( format DD"d" hh"g" mm"m"  )
must be        01d 01g 00m

Actual Results:
  

Expected Results:
  


Reproducible: Always


User Profile Reset: No

Additional Info:
Comment 1 Eike Rathke 2023-01-06 13:08:59 UTC 
Format DD does not display a duration in days but *Day of Month* for a date serial number. Your =A1-A2 yields 1.04167 (25h) that treated as date is null-date 1899-12-30 + 1.04167 => 1899-12-31 01:00:00 hence day 31 is displayed.

Not a bug.