Apache OpenOffice Community Forum

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

Look at the LEFT and MID functions.

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