Thank you Eike, I have put your idea into my sheets [simplified to =IF(A1*24<13;A1;A1-0.5) ; not as robust, but simpler to teach & sufficient for me] but my wife is unconvinced and thus I have logged Request for Improvment here:
http://www.openoffice.org/issues/show_bug.cgi?id=52327 Anyone with similar requirements for the simple TIME format may add your own vote to this request by following the above link. On 7/20/05, Eike Rathke <[EMAIL PROTECTED]> wrote: > Hi Warwick, > > On Tue, Jul 19, 2005 at 02:35:22 +1200, Warwick Taylor wrote: > > > Lots of things happen during the day > school timetables > > Lots of things happen during the evening > rehearsal timetables > > Kiwi's expect simplicity; not to be treated like simpletons. > > Ok, I see.. assuming the original clock time is in A1, the following > formula will display only time values between 00:00 and 12:59 if > formatted as HH:MM > > =IF(A1*24<13;A1;MOD(A1*24;12)/24) > > Eike > > -- > OOo/SO Calc core developer. Number formatter bedevilled I18N > transpositionizer. > GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD > > --------------------------------------------------------------------- > 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]
