https://bugs.documentfoundation.org/show_bug.cgi?id=166399
Bug ID: 166399
Summary: Text conversion of seconds to days, hours, minutes
returns incorrect value
Product: LibreOffice
Version: 24.8.6.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Using a formula of [=TEXT((A29)/(24*60*60),"d\d h\h m\m s\s")] when A29 is
86400 (i.e., 24*60*60) the formula returns an answer of 31d 0h 0m 0s. When A29
is 390193.54 the formula returns 3d 12h 23m 13s but the correct answer should
be 4d 12h 23m 13s.
The day portion of the calculation is not calculating correctly.
Steps to Reproduce:
1. Use formula =TEXT((A29)/(24*60*60),"d\d h\h m\m s\s")
2. In A29, enter 86400.
3.
Actual Results:
31d 0h 0m 0s
Expected Results:
0d 0h 0m 0s
Reproducible: Always
User Profile Reset: No
Additional Info:
Excel does not have this problem, but computes the answer correctly.
--
You are receiving this mail because:
You are the assignee for the bug.
