[libreoffice-users] How to do this in Calc

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