How to convert number in to time lenght, minutes and seconds?
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 |
How to convert number in to time lenght, minutes and seconds?
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" wrote in message ... 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 |
How to convert number in to time lenght, minutes and seconds?
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" wrote in message ... 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 |
How to convert number in to time lenght, minutes and seconds?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Bojan" wrote in message ... 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" wrote in message ... 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 |
All times are GMT +1. The time now is 11:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com