[Libreoffice-bugs] [Bug 49027] New: : time format code

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=49027

             Bug #: 49027
           Summary: : time format code
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.1 Release
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: BASIC
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: jvroonen at hotmail.com


Problem description: 
Using Time format code "[HH]:MM:SS" in format cell properties does not display
hours > 24.


Steps to reproduce:
1. In cell A1, type the number "11245" (without quotes), representing a number
of minutes.
2. In cell B1, type "=TIME(0;A1;0)"
3. Make sure that format cell properties is "Time", and that format code is
"[HH]:MM:SS".


Current behavior:
"19:25:00" is displayed

Expected behavior:
"187:25:00" should be displayed ; I asked "[HH]" formatting and not "HH".


Platform (if different from the browser): 
Browser: Mozilla/5.0 (Windows NT 6.0; rv:11.0) Gecko/20100101 Firefox/11.0

Thank you !

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.