Avatar of Geekamo
Geekamo
Flag for United States of America 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
Microsoft Excel

Avatar of undefined
Last Comment
Geekamo

8/22/2022 - Mon
barry houdini

Can you explain why C22 should be 24, why does 2 hours equate to 24?

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
Geekamo

ASKER
@ 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
ASKER CERTIFIED SOLUTION
barry houdini

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
Sign up - Free for 7 days
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
Geekamo

ASKER
@ barryhoudini,

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

~ Geekamo
Your help has saved me hundreds of hours of internet surfing.
fblack61