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

Thanks for reading, but I just manually formatted one page, and then I can
copy/paste to other pages.

Sorry for any inconvenience.

I'd still like to know how to do it though. I'm thinking a macro is really
what I need.



On Sat, Feb 7, 2015 at 2:22 PM, jerryvb <jerry.vb@gmail.com> 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.
>
> Thanks
>
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/How-to-do-this-in-Calc-tp4139304.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> 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


-- 
->Jerry<-

-- 
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