Bug 59009

Summary: Format [TT]:MM:SS doesn't always view hours>24 correctly
Product: LibreOffice Reporter: Grobe <regeirs.forum>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal    
Priority: medium    
Version: 3.6.4.3 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description Grobe 2013-01-04 02:36:38 UTC
Os version: Windows XP sp3

I go straight on with an example:

I have a cell with formula "=TIME(C2;D2;0)" and format "[TT]:MM:SS".
The contents of the cells: C2=52, D2=32.

Now, I would expect the cell appearance to be something like: "52:32:00". But instead, it appears as "04:32:00" wich is not what I expect.


Thanks
Comment 1 Zachariah Thomas 2013-02-12 19:36:16 UTC
The TIME function is designed to automatically convert 24+ hours into days and hours.