Issue 124943

Summary: format cell for [hh]:mm does not work anymore
Product: Calc Reporter: Chris <tschani>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Major    
Priority: P3    
Version: 4.1.0   
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
Issue Type: DEFECT Latest Confirmation in: 4.1.0
Developer Difficulty: ---
Description Flags
screen shot of my example none

Description Chris 2014-05-20 17:51:44 UTC
Created attachment 83436 [details]
screen shot of my example

in former versions you could format the cell for [hh]:mm to add time values, for example flight times. it is not possible now.
In the example on the screen shot, you can see my columns and on top you should see the summary of the flying hours below. But the value shown is not right, I donĀ“t know what it is calculating ..... 
The cells are formatted as "user defined - [hh]:mm" and as you can see, I do it this way since 2005 and it worked until now ......
Comment 1 mroe 2014-05-20 18:09:22 UTC
Please attach an example spreadsheet which shows the described behaviour.

But at first please format all time values with [HH]:MM:SS to see if there are wrong values.