Sorry for my posts going all over the place. Just learning how to use gmail for a mailing list.
See below... On Sat, Feb 7, 2015 at 4:43 PM, Brian Barker <[email protected]> wrote: > At 15:22 07/02/2015 -0700, Jerry Van Brimmer wrote: > >> Column A has the following data: >> 2015-01-06 00:00:00to 2015-01-06 01:00:00 >> >> I want a formula in column B to convert it to this: >> 00:00 - 01:00 >> >> This looks easy, I just don't have the know how to do it. It's basically >> a copy, minus the yyyy-mm-dd, and replacing the "to" with a dash. You can >> just point me in the right direction if you want, any help appreciated. >> > > With that intervening "to", the data in column A must be text, then? And > the result you want must also be text. Is column A formatted precisely in > that way in all (relevant) rows? If so, as you say, you just need to copy > some parts and reassemble them. > > Try: > =MID(A1;12;5)&" - "&MID(A1;34;5) > When I tried that I get in column B: e lnf - -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
