Description: We need the starting value (line 1) 00:02:08,657 rounded to full seconds. Steps to Reproduce: Please refer to the attached .ODS: We tried two versions Time formatted HH:MM:SS and [HH]:MM:SS, not understandable why [HH] provide the expected result for the seconds. Round to HH:MM:SS,00 or HH:MM:SS,0 works well. Actual Results: Please refer to the attached .ODS Expected Results: For 00:02:08,657 rounded to full seconds; the result of 00:02:09 is expected! Reproducible: Always User Profile Reset: No Additional Info: Issue found Version: 6.3.3.2 (x64) Build-ID: a64200df03143b798afd1ec74a12ab50359878ed CPU-Threads: 8; BS: Windows 10.0; UI-Render: Standard; VCL: win; Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE Calc: CL Version: 7.3.6.2 / LibreOffice Community Build ID: c28ca90fd6e1a19e189fc16c05f8f8924961e12e CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded
Created attachment 193709 [details] CALC: Time Rounding
HH:MM:SS is a clock format, it does not round into seconds. If it did, then 23:59:59.9 would result in 00:00:00 (24:00:00 but wrapped around), and along with a date (like YYYY-MM-DD HH:MM:SS) it even would display 00:00:00 of the next day. [HH]:MM:SS is a duration format that rounds and would display 24:00:00, similar for [MM]:SS and [SS]. If you still need to round into seconds along with a HH:MM:SS format then use =ROUND(B1*86400)/86400
(In reply to Eike Rathke from comment #2) > HH:MM:SS is a clock format, it does not round into seconds. If it did, then > 23:59:59.9 would result in 00:00:00 (24:00:00 but wrapped around), and along > with a date (like YYYY-MM-DD HH:MM:SS) it even would display 00:00:00 of the > next day. And what would be wrong if it does? The date has to show the next day, if rounded…