Hello,

I need a formula that can do the following:

-give an average minutes and seconds per phone call

This is the data that I will be entering:

Calls: 120
Total talk time (hours): 4
Total talk time (minutes): 47
Total talk time (seconds): 52

Thank you

Assuming the hours will not be greater than 23.

Try this:

B1 = 120
B2 = 4
B3 = 47
B4 = 52

=TIME(B2,B3,B4)/B1

Format as m:ss or h:m:ss

--
Biff
Microsoft Excel MVP


"Jimmy H" wrote in message
...
Hello,

I need a formula that can do the following:

-give an average minutes and seconds per phone call

This is the data that I will be entering:

Calls: 120
Total talk time (hours): 4
Total talk time (minutes): 47
Total talk time (seconds): 52

Thank you

Try this - the solution below did not work for me

=(B2&":"&B3&":"&B4)/B1

format as hh:mm:ss

edvwvw

Jimmy H wrote:
Hello,

I need a formula that can do the following:

-give an average minutes and seconds per phone call

This is the data that I will be entering:

Calls: 120
Total talk time (hours): 4
Total talk time (minutes): 47
Total talk time (seconds): 52

Thank you

--
Message posted via http://www.officekb.com