Bug 59009

Summary:	Format [TT]:MM:SS doesn't always view hours>24 correctly
Product:	LibreOffice	Reporter:	Grobe <regeirs.forum>
Component:	Calc	Assignee:	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.