Formatting conundrum

specky · Apr 12th, 2002, 04:48 AM

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 · Apr 12th, 2002, 05:21 AM

Quote:

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 · Apr 12th, 2002, 05:35 AM

Cheers - worked a treat.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 12th, 2002, 04:48 AM	#1
specky New Member Join Date: Apr 2002 Posts: 4	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?

Apr 12th, 2002, 05:35 AM	#3
specky New Member Join Date: Apr 2002 Posts: 4	Cheers - worked a treat.