Number to time minutes seconds

[GRock]

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]

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.]

=A1/1440

...and format as m:ss