Number to time minutes seconds

GRock · May 9th, 2002, 01:47 PM

How do i simply convert a cell with a value of say 11.5 into a cell that will say 11 minutes 30 seconds?

Aladin Akyurek · May 9th, 2002, 01:51 PM

Quote:

On 2002-05-09 08:47, GRock wrote:
How do i simply convert a cell with a value of say 11.5 into a cell that will say 11 minutes 30 seconds?

=A1/24

Time format the formula cell.

Addendum: I see I'm corrected. See Mark's reply.

[ This Message was edited by: Aladin Akyurek on 2002-05-09 10:48 ]

Mark W. · May 9th, 2002, 01:54 PM

=A1/1440

...and format as m:ss

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

May 9th, 2002, 01:47 PM	#1
GRock Join Date: May 2002 Posts: 1	How do i simply convert a cell with a value of say 11.5 into a cell that will say 11 minutes 30 seconds?

May 9th, 2002, 01:54 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,653	=A1/1440 ...and format as m:ss