Solved

Average Minutes Per Hour - Formula

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

867 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

16 Experts available now in Live!

Get 1:1 Help Now