Results 1 to 5 of 5

Thread: I need help ASAP

  1. #1

    Lightbulb I need help ASAP



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need help finding out what formula to figure out the pay rate depending on how many minutes I do as different amount of minutes mean different pay as shown in table. Any body knows? PLZ Click image for larger version. 

Name:	Screen Shot 2014-11-24 at 3.00.18 PM.png 
Views:	14 
Size:	33.3 KB 
ID:	2888


    Date: 11/19/2014 Minutes Price
    Timein TimeOut Total Time Worked Pay Rate 37 minutes or less $13
    11:00AM 12:00 PM 0:25 ? between 38 minutes to 54 minutes $23
    12:02PM 12:47 PM 0:48 ? 55 minutes or more $32

  2. #2
    I was given this below in BOLD to use for solving a problem now I have no idea how to use it or apply it.


    Build your own function. (record a macro, click any cell, stop macro)
    Goto the VB Evironment, (in the project window, in the MODULE1)
    overwrite the macro1 with the code below:

    Code:

    Public Function CalcRate(ByVal pvMin) Select Case pvMin Case <38 CalcRate = 13 Case >54 CalcRate = 32 case else CalcRate = 23End Selectend Function

  3. #3
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi Mokacolt,
    Plz find attached file, I hope it may solve your problem.
    Attached Files Attached Files

  4. #4
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    742
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Actually the function you got at http://www.mrexcel.com/forum/excel-q...i-can-use.html works fine.

    The way you calculate and format your Total Time Worked...... not so much.

    Check out http://www.contextures.com/xlvba01.html for where to put code you are given.

  5. #5
    WOW!! Thank you soo much I myself was trying to do the IF function but always ended up being an error!! Thank you soo much!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •