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]
