https://bugs.documentfoundation.org/show_bug.cgi?id=160696
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.documentfounda | |tion.org/show_bug.cgi?id=15 | |0049 Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #2 from Eike Rathke <[email protected]> --- 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 -- You are receiving this mail because: You are the assignee for the bug.
