Split Cells

Discuss the spreadsheet application

Split Cells

Postby kik94 » Mon Feb 18, 2019 9:08 am

Hello i have spreadsheet and i have some data in column A that looks like this :

they are in time format

Now what i want is a formula so that i can split them into column B and C . In B column there will be the 1st 2 digits before ":" and in C the 2 digits after them. For example : the 00:15 in A will become 00 in B and 15 in C
the 01:30 in A will become 01 in B and 30 in C

Any idea how i could do this ? thanks in advance
Libre Office (x64)
Posts: 4
Joined: Fri Feb 08, 2019 10:44 am

Re: Split Cells

Postby robleyd » Mon Feb 18, 2019 9:32 am

Look at the LEFT and MID functions.
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice (SlackBuild for 6.4.6 by Eric Hameleers) - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
Posts: 3643
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Split Cells

Postby Lupp » Mon Feb 18, 2019 10:08 am

@kik94: Once again you posted the same question in (at least) two forums without mentioning the fact and without giving links.
I already pointed you to the fact that this is considered for good reasons to be a violation of good practice.
I will not answer your requests any longer If you don't change your behaviour insofar.

See also: https://ask.libreoffice.org/en/question ... lit-cells/
On Windows 10: LibreOffice 7.0 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
Lupp from München
User avatar
Posts: 2980
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Return to Calc

Who is online

Users browsing this forum: No registered users and 24 guests