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