Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert time in number of seconds | Excel Worksheet Functions | |||
How do I change a minutes and seconds as a 2400 time to seconds? | Excel Worksheet Functions | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
How do i convert a number of seconds to a date/time? | Excel Worksheet Functions | |||
Convert seconds to minutes and seconds in excel | Excel Worksheet Functions |