Hi,
I work in a Contact centre and curently we measure the lenght of talking
time of a particular person in seconds.
For example John Smith talked 255 seconds, I need to convert those 255
seconds in to length format of minutes and seconds which is: 2:15 and then to
take the average time in minutes and seconds
Is there a formula to do this? To convert the seconds at A3 into time length
at B3.

Sec Time Sec Time Average
A3 B3 C3 D3 E3
255 2:15 160 3:00 2:37

Thank you

>I need to convert those 255 seconds in to length format
>of minutes and seconds which is: 2:15

255 seconds is 4:15.

Divide by 86400

A3 = 255

=A3/86400

Format as [m]:ss

For the average:

=AVERAGE(B3,D3)

Also format as [m]:ss

--
Biff
Microsoft Excel MVP


"Bojan" <(E-Mail Removed)> wrote in message
news:7D2E9BA5-1B44-4ABA-96EB-(E-Mail Removed)...
> Hi,
> I work in a Contact centre and curently we measure the lenght of talking
> time of a particular person in seconds.
> For example John Smith talked 255 seconds, I need to convert those 255
> seconds in to length format of minutes and seconds which is: 2:15 and then
> to
> take the average time in minutes and seconds
> Is there a formula to do this? To convert the seconds at A3 into time
> length
> at B3.
>
> Sec Time Sec Time Average
> A3 B3 C3 D3 E3
> 255 2:15 160 3:00 2:37
>
> Thank you

Thanks that's great help, It works.


"T. Valko" wrote:

> >I need to convert those 255 seconds in to length format
> >of minutes and seconds which is: 2:15
>
> 255 seconds is 4:15.
>
> Divide by 86400
>
> A3 = 255
>
> =A3/86400
>
> Format as [m]:ss
>
> For the average:
>
> =AVERAGE(B3,D3)
>
> Also format as [m]:ss
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Bojan" <(E-Mail Removed)> wrote in message
> news:7D2E9BA5-1B44-4ABA-96EB-(E-Mail Removed)...
> > Hi,
> > I work in a Contact centre and curently we measure the lenght of talking
> > time of a particular person in seconds.
> > For example John Smith talked 255 seconds, I need to convert those 255
> > seconds in to length format of minutes and seconds which is: 2:15 and then
> > to
> > take the average time in minutes and seconds
> > Is there a formula to do this? To convert the seconds at A3 into time
> > length
> > at B3.
> >
> > Sec Time Sec Time Average
> > A3 B3 C3 D3 E3
> > 255 2:15 160 3:00 2:37
> >
> > Thank you
>
>
>

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Bojan" <(E-Mail Removed)> wrote in message
news:1853746C-E8AD-40BF-A354-(E-Mail Removed)...
> Thanks that's great help, It works.
>
>
> "T. Valko" wrote:
>
>> >I need to convert those 255 seconds in to length format
>> >of minutes and seconds which is: 2:15
>>
>> 255 seconds is 4:15.
>>
>> Divide by 86400
>>
>> A3 = 255
>>
>> =A3/86400
>>
>> Format as [m]:ss
>>
>> For the average:
>>
>> =AVERAGE(B3,D3)
>>
>> Also format as [m]:ss
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Bojan" <(E-Mail Removed)> wrote in message
>> news:7D2E9BA5-1B44-4ABA-96EB-(E-Mail Removed)...
>> > Hi,
>> > I work in a Contact centre and curently we measure the lenght of
>> > talking
>> > time of a particular person in seconds.
>> > For example John Smith talked 255 seconds, I need to convert those 255
>> > seconds in to length format of minutes and seconds which is: 2:15 and
>> > then
>> > to
>> > take the average time in minutes and seconds
>> > Is there a formula to do this? To convert the seconds at A3 into time
>> > length
>> > at B3.
>> >
>> > Sec Time Sec Time Average
>> > A3 B3 C3 D3 E3
>> > 255 2:15 160 3:00 2:37
>> >
>> > Thank you
>>
>>
>>