[Libreoffice-bugs] [Bug 118800] HOUR function>> 24 is displayed instead of 0(zero) if Number argument in the range from -0.000001 to min negative number.

[bugzilla-daemon at bugs.documentfoundation.org]

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

raal <raal at post.cz> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Blocks|                            |108827
                 CC|                            |raal at post.cz
             Status|UNCONFIRMED                 |NEW

--- Comment #1 from raal <raal at post.cz> ---
definition 6.10.10 HOUR
Summary: Extracts the hour (0 through 23) from a time.
Syntax: HOUR( TimeParam T )
Returns: Number
Constraints: None
Semantics: Extract from T the hour value, 0 through 23, as per a 24-hour clock.
This is equal to:
DayFraction=(T-INT(T))
Hour=INT(DayFraction*24)

confirm with Version: 6.2.0.0.alpha0+
Build ID: d11313f341d1d9a9c73c736932441a89d5292e37
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3;


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
[Bug 108827] [META] Calc functions bugs and enhancements
-- 
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/20180717/59179970/attachment.html>