Issue 124943 - format cell for [hh]:mm does not work anymore
Summary: format cell for [hh]:mm does not work anymore
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.0
Hardware: PC Windows 7
: P3 Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2014-05-20 17:51 UTC by Chris
Modified: 2014-05-20 18:09 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0
Developer Difficulty: ---

screen shot of my example (151.60 KB, image/jpeg)
2014-05-20 17:51 UTC, Chris
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.