Re: [libreoffice-users] How to do this in Calc

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 <b.m.barker@btinternet.com>
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: users+unsubscribe@global.libreoffice.org
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