https://bugs.documentfoundation.org/show_bug.cgi?id=153139
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #2 from ady <[email protected]> --- (In reply to apprendista.programmatore+Bugzilla from comment #0) > I want the time of R4 (see image) to appear in Q4 rounded down to the half > hour. Only, I suppose because of the miscalculated remainder, in the case of > only 30 minutes instead of giving 0 it gives a higher value. Even with -30 > it gives an error. It works correctly up to 29 minutes and from 31 and up, > even at 1:30 it works. I think the problem is how that specific cell with "00:30" is being interpreted: Calc is not taking it as "half an hour" (i.e. a time-difference) but rather "12:30 AM" (i.e. a time of the day). "12:30 AM" would translate to "50/2400" (0.0208333333333333), whereas "half an hour" would be "1/2" (0.5). Since ATM there is no spreadsheet file attached, I am only making assumptions. Can you please confirm all this? -- You are receiving this mail because: You are the assignee for the bug.
