Bug 96460 - Incorrect display of hours format
Summary: Incorrect display of hours format
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-12-13 16:43 UTC by m.faeth
Modified: 2015-12-13 18:29 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
picture of simple formatting a number as hours (12.97 KB, image/png)
2015-12-13 16:43 UTC, m.faeth 		Details
printscreen (96.28 KB, image/png)
2015-12-13 18:29 UTC, raal 		Details
View All 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 m.faeth 2015-12-13 16:43:08 UTC 
Created attachment 121270 [details]
picture of simple formatting a number as hours

Calc can display numbers as hours. 

This works well with numbers lower that 1 (i.e 1 day). However, if a number is higher than 1 (day), calc will display only the hours of the last day (e.g. 1,5 will be shown as 12:00 hours instead of 36:00 hours). 

In the editor line it shows the correct hours - see picture.

Desired behaviour: calc should display hours correctly.
Comment 1 raal 2015-12-13 18:29:01 UTC 
Created attachment 121272 [details]
printscreen

Hello, use the format [HH]:MM:SS