formula to convert minutes and seconds into just seconds

[chriscim]

at work i have to input time for the average
lenght of the call and then convert into seconds.
is there a formula to do so
like a1 is 3:15
in b1 i want a formula to convert the 3:15 into just seconds which would be 195

thanks

[Mark W.]

If cell A1 contains a time value formatted as m:ss then enter the following formula in cell B1...

=A1*86400

If cell A1 contains "3:15" use...

=TIMEVALUE("0:"&A1)*86400

[ This Message was edited by: Mark W. on 2002-04-23 11:03 ]

[chriscim]

thanks
just what i was looking for
how did u know that formula

chris

[chriscim]

also do u know what the formula is to convert back into minutes and seconds

thanks
chris

[Mark W.]

On 2002-04-23 11:08, chriscim wrote:
thanks
just what i was looking for
how did u know that formula

chris

Which formula did you use?

[chriscim]

the second one

[Mark W.]

On 2002-04-23 11:11, chriscim wrote:
also do u know what the formula is to convert back into minutes and seconds

thanks
chris

=TEXT(B1/86400,"m:ss")

where B1 contains the seconds as an integer.

[Mark W.]

On 2002-04-23 11:08, chriscim wrote:
thanks
just what i was looking for
how did u know that formula

chris

Excel stores time values as a fractional part of a day... there are 86,400 seconds in a day. Excel time values are entered as hours:minutes or hours:minutes:seconds so...

=TIMEVALUE("0:"&A1)*86400

...first converts your text string to a time value and then converts that fraction of a day into seconds.