[mso] Re: Excel Formula

  • From: "Chuck Hawsey" <chawsey@xxxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Thu, 22 Jun 2006 04:49:48 -0500

Linda,
B is a manually entered number of the number of minutes a person works in a 
shift. That number is usually 450 minutes. However, it could be anywhere from 
60 minutes to 600 or so minutes.  I'd like the formula in E to show the number 
of adjusted calls (based on the number entered in D plus C divided by 32). For 
example, a person works 450 minutes(B), has 64 minutes downtime(C) , and 
completed 8 calls (D). The number in E (by formula) would be 10.  If the person 
only worked 260 minutes (B), had 64 minutes downtime, and completed 8 calls, 
the number appearing in E would still be 10. However, I'd like it to adjust to 
the number of adjusted calls he or she would have if he or she had worked 450 
minutes. I think it would have to represent: 260 minutes is to 10 as 450 
minutes is to X.  I hope that explains it a little better. I may have to call!  
:)

Chuck H.

This email and any attachments have been scanned by Norton AV Version 11.0.16.2
  ----- Original Message ----- 
  From: Linda F. Johnson 
  To: mso@xxxxxxxxxxxxx 
  Sent: Wednesday, June 21, 2006 9:54 PM
  Subject: [mso] Re: Excel Formula


  Sorry. You lost me.  What are you currently doing with the number in B if it
  IS 450?  Your formula refers to D and C, but not B ... You say you need E to
  show what it would have been if 450 was in B, but your formula doesn't refer
  to B at all.  So, how does what is in B effect what is in E?


  Linda F. Johnson
  Linda's Computer Stop
  Author, MOS: Excel 2003 Study Guide, published by John Wiley and Sons
  http://personal-computer-tutor.com

  -----Original Message-----
  From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
  Of Chuck Hawsey
  Sent: Wednesday, June 21, 2006 8:50 PM
  To: mso@xxxxxxxxxxxxx
  Subject: [mso] Excel Formula

  Well, here I am with need of a formula that - hopefully - is at least a
  little harder than the last one I asked!  I'm not sure how to describe what
  I need, so let me try this:
  A.               B                        C                        D          
                  E
              
  Name    minutes worked    downtime        actual calls made        adjusted
  # of calls


  A is self explanatory
  B contains the number of minutes worked - usually 450, but it can vary
  greatly
  C contains a manually entered number of minutes a person spent on
  miscellaneous items. For each 32 minutes, he/she gets credit for one
  adjusted call.
  D contains a manually entered number of actual calls made by that person
  during the minutes he/she worked
  E contains a formula that presently adds the number in D to C divided by 32

  Here's my problem. If B contains a number other than 450, I want E to
  represent the number of adjusted calls he/she would have had if he/she had
  actually worked 450 minutes.  In other works, I'm looking for a formula like
  a ratio, for example, if B contained 248 minutes worked and D contained 8
  calls, then I need the number if E to be what it would have been if B had
  contained 450 minutes worked.

  Gosh, I hope this makes sense, as I find it hard to explain and even harder
  to come ;up with a formula. Any assistance will be greatly appreciated. If
  anyone needs more information or needs the actual present spreadsheet, I
  will be happy to provide it.

   

  Chuck H.

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: