<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Basic -timeserial function minutes outside the range 0-59"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114229#c12">Comment # 12</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Basic -timeserial function minutes outside the range 0-59"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114229">bug 114229</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=151960" name="attach_151960" title="Testing results with Excel 2016">attachment 151960</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=151960&action=edit" title="Testing results with Excel 2016">[details]</a></span>
Testing results with Excel 2016
The code tested was:
<span class="quote">> Sub testTimeSerial()
> Dim result As String
> Dim i As Long
> Dim h As Long, m As Long, s As Long
> For h = -30 To 30 Step 2
> For m = -70 To 70 Step 10
> For s = -70 To 70 Step 10
> i = i + 1
> Cells(i, 1) = h
> Cells(i, 2) = m
> Cells(i, 3) = s
> Cells(i, 4) = testImpl(h, m, s)
> Next s
> Next m
> Next h
> End Sub
>
> Function testImpl(h As Long, m As Long, s As Long) As String
> On Error GoTo errHandler
> testImpl = TimeSerial(h, m, s)
> Exit Function
> errHandler:
> testImpl = "Error: " & Err
> End Function</span ></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>