https://bugs.documentfoundation.org/show_bug.cgi?id=153139
--- Comment #5 from [email protected] --- I try edit the formula in =IF(P4<>"";Q4-MOD(FLOOR(Q4;$X$1/2*SIGN(Q4));1/48);"") But now in R it copies the minutes of Q always. At least, I tried 29:00 and got 29:00 not 0. What I want to achieve is to separate the whole half hours from the minutes, in other words: if P4 is valorized do the calculations, otherwise nothing if it is 0 I hide with formatting, so I don't put it in formula tmp=resto division(time, 30:00) write Q-tmp hope I didn't confuse The crazy thing is that if I remove the formula part of the initial if, it works correctly, only it shows error if P is empty -- You are receiving this mail because: You are the assignee for the bug.
