[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #11 from Eike Rathke <erack at redhat.com> ---
Seems the implementation is the linked VBA reference "each TimeSerial argument
should be in the normal range for the unit; that is, 0–23 for hours and 0–59
for minutes and seconds" part, not considering the following any 16-bit integer
is possible for each argument. The "if the time specified by the three
arguments causes the date to fall outside the acceptable range of dates, an
error occurs." sounds as if more than 24 hours are possible; Excel doesn't
handle negative dates so a resulting value of <0 would not be possible, but how
about VBA? And what about values >=0 24 hours?

@Mike, can you check?

Our own help says the individual arguments can have any numeric value, but also
restricts the result to be between 0 and 0.9999999999 (which in this case is
between 00:00:00 and 23:59:59). This actually make most sense to me and IMHO
implementation should follow that.

-- 
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/20190605/08e88f66/attachment.html>