coverting seconds to minutes

[Escher]

i am working on a spreadsheet for my call center...

our switch is old and it pulls data off in seconds

i want to be able to convert seconds to minutes... easier to read

lets say my seconds are 364
i want to convert that into mm:ss

what is the formula... i am having a brain fart = )

 

[NateO]

+364/60

 

[Aladin Akyurek]

On 2002-04-05 13:27, Escher wrote:
i am working on a spreadsheet for my call center...

our switch is old and it pulls data off in seconds

i want to be able to convert seconds to minutes... easier to read

lets say my seconds are 364
i want to convert that into mm:ss

what is the formula... i am having a brain fart = )

=A1/86400

Custom format the cell as mm:ss

 

[NateO]

Or =time(,,364) and format precisely as Al mentioned. At least in xl2000...

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>
This message was edited by NateO on 2002-04-05 13:34

 

[Escher]

aladin got it.. thanks alot
This message was edited by Escher on 2002-04-05 13:35