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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@ barryhoudini,
You got it! It's perfect. Thank you so much!
~ Geekamo
You got it! It's perfect. Thank you so much!
~ Geekamo
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