Help with formula please

  • Thread starter Thread starter Jimmy H
  • Start date Start date
J

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
 
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
 
Back
Top