I'm currently trying to convert a cell which contains the number of seconds into another cell which show the seconds as minutes and seconds using the following formula:
=QUOTIENT(C2,60)&MOD(C2,60)
where C2 is the cell containing the number of seconds I want to convert. My problem is that the formula works well but I've found now that I cannot display the results as mm:ss which is what I'd like.
Is anyone able to help me?
=QUOTIENT(C2,60)&MOD(C2,60)
where C2 is the cell containing the number of seconds I want to convert. My problem is that the formula works well but I've found now that I cannot display the results as mm:ss which is what I'd like.
Is anyone able to help me?