https://bugs.documentfoundation.org/show_bug.cgi?id=147825
Bug ID: 147825
Summary: FORMAT CELLS in Calc will not hold more than 23 hours
even when set to [HH]:MM:SS
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The time format to prevent HH MM SS to roll over has a hard 24 hour limit.
If I set the format to HH:MM:[SS] the maximum amount of seconds is 86399, which
is 23 hrs 59 min 59 sec. Also the minutes max out at 1439 and then roll over to
zero.
Using the square brackets I can prevent the minutes and seconds rollover at 59,
but I am not able to get more than 23 hours.
With the use of the square brackets maximum:
HH is 23
MM is 1439
SS is 86399
Steps to Reproduce:
1.Enter a number larger than 86399 in a cell (e.g. in A1)
2.Enter =TIME(0,0,A1) in 3 other cells (e.g. B1,B2,B3)
3.Set format of cell B1 to category: Time with format: HH:MM:[SS]
4.Set format of cell B2 to category: Time with format: HH:[MM]:SS
5.Set format of cell B1 to category: Time with format: [HH]:MM:SS
Actual Results:
Whatever is entered in the first cell (A1), the results in the three other
cells will never exceed 23 hours, never exceed 1439 minutes and never exceed
86399 seconds. When 86400 is entered the three other cells show 00:00:00
Expected Results:
The three cells should reflect the total amount of seconds even if it is larger
86399 and show the corresponding amount of minutes or hours depending on where
the brackets are used.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.4.7.2
Build ID: 1:6.4.7-0ubuntu0.20.04.2
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3;
Locale: en-GB (en_US.UTF-8); UI-Language: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
