Improve company productivity with a Business Account.Sign Up

x
?
Solved

Average Minutes Per Hour - Formula

Posted on 2012-12-30
4
Medium Priority
?
497 Views
Last Modified: 2012-12-30
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
0
Comment
Question by:Geekamo
  • 2
  • 2
4 Comments
 
LVL 50

Expert Comment

by:barry houdini
ID: 38731381
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
0
 
LVL 1

Author Comment

by:Geekamo
ID: 38731391
@ 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
0
 
LVL 50

Accepted Solution

by:
barry houdini earned 2000 total points
ID: 38731403
OK, I think I understand - try this formula in C22

=C19/(C5-C4-C6)*60

format C22 as number

regards, barry
0
 
LVL 1

Author Comment

by:Geekamo
ID: 38731406
@ barryhoudini,

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

~ Geekamo
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article describes a serious pitfall that can happen when deleting shapes using VBA.
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question