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 :

00:15
01:30
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 6.1.3.2 (x64)
kik94
 
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.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2936
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 6.2 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2528
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany


Return to Calc

Who is online

Users browsing this forum: BillAmes, Google [Bot] and 21 guests