SPLIT CELLS (HOURS)
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