How do I get numbers before and after a colon within a cell in Calc?
- by Dave M G
I have some cells which contain times entered in by users, which are written in the following format: mm:ss. There are never any hours. The seconds always have leading zeroes. The minutes may or may not have leading zeros.
Because I need to separate out the minutes and seconds for various operations, I need to be able to get at the numbers before and after the colon.
How do I select the number before a colon in a cell, and how do I select the number after?