Help with formula please


Jimmy H


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


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