[Libreoffice-bugs] [Bug 118596] New: 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

            Bug ID: 118596
           Summary: Calc equation
                    =1/(MINUTE(TIME(7,30,0))-MINUTE(TIME(21,30,0))) gives
                    divide by zero error
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: tgru001 at gmail.com

Description:
=1/(MINUTE(TIME(7,30,0))-MINUTE(TIME(21,30,0))) gives divide by zero error.
=1/(MINUTE(TIME(7,30,0))-MINUTE(TIME(21,31,0))) gives a real answer.
It looks as though if the minute part of two times subtract to zero calc
assumes the whole answer in minutes is zero for the purposes of recording a
divide by zero error.
My work around has been to add one minute to the second time value which for my
study is not significant.

Steps to Reproduce:
1.Start libre office calc
2. enter equation =1/(MINUTE(TIME(7,30,0))-MINUTE(TIME(21,30,0))) into cell
3.

Actual Results:
Divide by zero error

Expected Results:
a number 0.00 if cell format set to number with 2 decimal places.


Reproducible: Always


User Profile Reset: No



Additional Info:
Produced a value, 0.00 if cell format set to number with 2 decimal places.

-- 
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/20180706/ef6bf1e9/attachment.html>