Solved

Average Minutes Per Hour - Formula

Posted on 2012-12-30
4
437 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 500 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
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.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

760 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now