asked on # Average Minutes Per Hour - Formula

Hello Experts!

The formula I need help with, would be located in cell C22.

Here's a brief overview of my calculator...

For every 1 hour that I work, it is required that I have 24 minutes of Talk Time.

In the example attached, you can see I made 4 calls - that all lasted 30 minutes each. Which gives me a total of 2 hours of talk time for the day.

Cell C22, should say "24" - but I don't know how to write the formula.

* Please check out how my formulas are interacting which each other. I'm sure that will be the easiest way to figure out what's going on before you provide a possible solution.

If you need anymore information, please don't hesitate to ask!

Thank you in advance!

~ Geekamo

Calculator.xls

The formula I need help with, would be located in cell C22.

Here's a brief overview of my calculator...

For every 1 hour that I work, it is required that I have 24 minutes of Talk Time.

In the example attached, you can see I made 4 calls - that all lasted 30 minutes each. Which gives me a total of 2 hours of talk time for the day.

Cell C22, should say "24" - but I don't know how to write the formula.

* Please check out how my formulas are interacting which each other. I'm sure that will be the easiest way to figure out what's going on before you provide a possible solution.

If you need anymore information, please don't hesitate to ask!

Thank you in advance!

~ Geekamo

Calculator.xls

Microsoft Excel

@ barryhoudini,

24 would represent how many minutes per hour I am on the phone.

Based on the start & end time, there is 5 working hours. For every hour, I need 24 minutes of talk time. If I'm there for a whole shift, there would mean I need to talk on the phone for 2 hours, which would break down to 24 minutes per hour of talk time.

IE - If I was to work 5 hours, and my total talk time for the day was like 1 hour and 30 minutes, well my minutes per hour would be like 20 or something minutes per hour.

I hope that clarifies things... :)

~ Geekamo

24 would represent how many minutes per hour I am on the phone.

Based on the start & end time, there is 5 working hours. For every hour, I need 24 minutes of talk time. If I'm there for a whole shift, there would mean I need to talk on the phone for 2 hours, which would break down to 24 minutes per hour of talk time.

IE - If I was to work 5 hours, and my total talk time for the day was like 1 hour and 30 minutes, well my minutes per hour would be like 20 or something minutes per hour.

I hope that clarifies things... :)

~ Geekamo

Log in or sign up to see answer

Become an EE member today7-DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform

or

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.

Not exactly the question you had in mind?

Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.

ask a question
@ barryhoudini,

You got it! It's perfect. Thank you so much!

~ Geekamo

You got it! It's perfect. Thank you so much!

~ Geekamo

Your help has saved me hundreds of hours of internet surfing.

fblack61

This formula will give yo 24 based on the amount in C19

=C19*12*24

format C22 as general

.......but I'm not sure that's what you want

regards, barry