[Libreoffice-bugs] [Bug 118596] Calc equation =1/(MINUTE(TIME(7, 30, 0))-MINUTE(TIME(21, 30, 0))) gives divide by zero error

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118596

Aron Budea <baron at caesar.elte.hu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |baron at caesar.elte.hu
         Resolution|---                         |NOTABUG

--- Comment #1 from Aron Budea <baron at caesar.elte.hu> ---
Please note that MINUTE(...) function returns an integer between 0 and 59, ie.
the minute part of the time.

If you want to calculate the difference between two times in minutes, you need
to account for the hours as well (if the difference is less than a day,
otherwise for days, too).

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180707/74577cfd/attachment.html>