<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:baron@caesar.elte.hu" title="Aron Budea <baron@caesar.elte.hu>"> <span class="fn">Aron Budea</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Calc equation =1/(MINUTE(TIME(7,30,0))-MINUTE(TIME(21,30,0))) gives divide by zero error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118596">bug 118596</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>baron@caesar.elte.hu
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Calc equation =1/(MINUTE(TIME(7,30,0))-MINUTE(TIME(21,30,0))) gives divide by zero error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118596#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Calc equation =1/(MINUTE(TIME(7,30,0))-MINUTE(TIME(21,30,0))) gives divide by zero error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118596">bug 118596</a>
from <span class="vcard"><a class="email" href="mailto:baron@caesar.elte.hu" title="Aron Budea <baron@caesar.elte.hu>"> <span class="fn">Aron Budea</span></a>
</span></b>
<pre>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).</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>