Formatting conundrum

[specky]

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?

 

[Ivan F Moala]

On 2002-04-12 03:48, specky wrote:
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?

Try formula = =C2/(60*60*24)

and custom format cell as "mm:ss"

 

[specky]

Cheers - worked a treat.