Help with formula please

[Jimmy H]

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

 

[T. Valko]

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