Bug 49027 - : time format code
Summary: : time format code
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.1 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-04-20 14:28 UTC by Julien Vroonen
Modified: 2012-04-28 09:51 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Julien Vroonen 2012-04-20 14:28:10 UTC 
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 !
Comment 1 Ferran Vidal 2012-04-22 11:11:19 UTC 
[Reproducible] with "LibreOffice 3.5.2.2 - GNU/Linux Ubuntu 11.10,English
UI"
Comment 2 vitriol 2012-04-22 11:28:40 UTC 
This behavior is not related with the cell format, but with the function TIME() that not return values > 24 h.
It's not a bug for me..
Comment 3 Markus Mohrhard 2012-04-23 14:43:04 UTC 
OpenFormula specifies that Time always returns values between 00:00 and 24:00, so this is not a bug.
Comment 4 Julien Vroonen 2012-04-28 09:51:17 UTC 
I think that what I described is functional in Openoffice and Excel, but ok... If it is a "feature", I will change my formula to achieve what i want.

Thanks for your feedback