Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||format cell for [hh]:mm does not work anymore|
|Component:||formatting||Assignee:||AOO issues mailing list <issues>|
|Status:||UNCONFIRMED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||4.1.0|
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.