If this is a simple string, then the extract is quite simple. But if it
contains date formulas in a way, it is a wee more complicated. But let
us start with the simple assumption, that the string is exactly the one
you give, including e.g. the lacking space before "to":
Assuming your string is in cell A1, cell B1 could contain:
=CONCATENATE(MID(A1,12,5)," - ",MID(A1,34,5))
A wee more safe could be:
=CONCATENATE(MID(A1,12,5)," - ",LEFT(RIGHT(A1,8),5))
Both these give the result you wanted. But what if the date is not the
same, which result do you wish then? In that case I think you should do
transforms into date format (DATEVALUE), but much depends on what you
really want.
Den 2015-02-08 00:23, skrev "J. Van Brimmer":
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 <[email protected]> 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: [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
--
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
