coverting seconds to minutes

Escher · Apr 5th, 2002, 02:27 PM

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 · Apr 5th, 2002, 02:28 PM

+364/60

Aladin Akyurek · Apr 5th, 2002, 02:31 PM

Quote:

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 · Apr 5th, 2002, 02:33 PM

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

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-04-05 13:34 ]

Escher · Apr 5th, 2002, 02:34 PM

aladin got it.. thanks alot

[ This Message was edited by: Escher on 2002-04-05 13:35 ]

Apr 5th, 2002, 02:28 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	+364/60 __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

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

Apr 5th, 2002, 02:27 PM	#1
Escher New Member Join Date: Apr 2002 Location: dallas tx Posts: 13	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 = )

Apr 5th, 2002, 02:33 PM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Or =time(,,364) and format precisely as Al mentioned. At least in xl2000... _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-04-05 13:34 ]

Apr 5th, 2002, 02:34 PM	#5
Escher New Member Join Date: Apr 2002 Location: dallas tx Posts: 13	aladin got it.. thanks alot [ This Message was edited by: Escher on 2002-04-05 13:35 ]