Help with formula please


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
 
Ad

Advertisements

T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top