Thank you Howard, this issue may have been around for some time as we are using 1.1.2.
If no solutions pop up soon I may submit a "request for feature". Having not done this before, I searched this user group and found this "How To" by Peter Kupfer <START SNIP>................ The best way to have problems such as this evaluated is to file an issue. To do that, follow this link: <http://qa.openoffice.org/issue_handling/pre_submission.html> If you haven't already registered at the OpenOffice.org website, you will need to do so. You can do that by following this link: <http://www.openoffice.org/servlets/Join> Fill in your information and reply to the confirmation email that will be sent to the address you provided. Once you have confirmed, then go submit the issue HTH, -- Peter Kupfer -- Using OOo since 'OO4 -- [EMAIL PROTECTED] Want to help? http://www.oooauthors.org For OOo tips: http://openoffice.peschtra.com/tips/ooo_tips_tricks.html To order OOo: http://openoffice.peschtra.com/distro/ooo_distro.html - Show quoted text - .........................<END SNIP> On 7/18/05, Howard Coles Jr. <[EMAIL PROTECTED]> wrote: > It doesn't work that way, at least it didn't on 1.9.113 as I tried it this > morning. If you leave off the "AM/PM" part the thing reverts to 24 hour > format. Try your testing doing what you said before on 16:30:22 in the cell > or 4:30:22 PM. What you will probably notice is that as soon as you take > away the "AM/PM" format code in the properties of the cell, it will revert to > 24 hour format. > > What we need is a way to format it in AM/PM without having to have the AM or > PM at the end of the time. > > On Sunday 17 July 2005 03:21 pm, David Chapman wrote: > > It is pretty straightforward to do this.. > > > > Open the Fomat - Cells dialog and select the Numbers tab. > > > > Slect Time and examine the different options while obseving the Format > > Code. > > > > For 9:37 AM, the format code is HH:MM AM/PM > > > > For 9:37, the format code is HH:MM > > > > You can directly modify any Format Code in this dialog to get the > > customized effect youneed. > > > > Dave > > > > On 7/17/05, G. Roderick Singleton <[EMAIL PROTECTED]> wrote: > > > On Mon, 2005-07-18 at 00:55 +1200, Warwick Taylor wrote: > > > > Hi All > > > > > > > > I would like to have in Calc the time to show as AM/PM cell format [ie > > > > not 24hr] without showing the AM or PM bit. [In NZ, am/pm format is > > > > esentially universial, and as such, taken as expected; so showing "AM" > > > > or "PM" in a lot of situations is redundant, and in my present > > > > particular instance, particularily annoying.] > > > > > > > > I am presently hacking around it by overlaying a blank text box > > > > overtop of the offending letter but that is not a teachable solution > > > > for my wife, she would just laugh at me! > > > > > > > > Help? > > > > > > AM/PM is a cell format option for time. It should just work. Try Help > > > > Contents > Index > Search term > times;in cells to see if this > > > unconfuses the situation. > > > -- > > > PLEASE KEEP MESSAGES ON THE LIST. > > > OpenOffice.org <http://OpenOffice.org> Documentation Co-Lead > > > http://documentation.openoffice.org/ > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > -- > > See Ya' > Howard Coles Jr. > John 3:16! > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
