+ Reply to Thread
Results 1 to 2 of 2

multiply hours by dollars if hours are within certain range

  1. #1
    Registered User
    Join Date
    09-05-2013
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2010
    Posts
    19

    multiply hours by dollars if hours are within certain range

    Hi! I'm hoping someone can help me, please! I need to multiply the number of hours by a daily rate if the hours are 4 hours or more. and I need to multiply the number of hours by an hourly rate if the number of hours is 3 or less. I need it to round up to the next hour if the number of minutes is greater than 15. My formula is working great except for when the hours are 4 and the minutes are from 0 to 14 it wants to multiply by the daily rate. I'm thinking I need the hour qualifier in the beginning of the formula so that it will test if it is four hours and stop and not mess with the minutes? I tried to fix it and I ending up getting the daily rate when I had 3:16 minutes for example because it was rounding to 4. 3:16 minutes would only be the hourly rate because it wasn't actually greater than 4 hours. Any thoughts? Following is my formula:$A$83 is the daily rate and $A$84 is the hourly rate,
    =IF(IF(MINUTE(AA3)<=14,HOUR(AA3),HOUR(AA3)+1)>4,$A$83,IF(MINUTE(AA3)<=14,HOUR(AA3),HOUR(AA3)+1)*$A$84)
    I would greatly appreciate any help that could be offered.
    Thanks again.
    Angela

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: multiply hours by dollars if hours are within certain range

    start it with this...
    =if(hour(AA3)>4,A83,
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cells not updating hours worked? Converting time and dollars?
    By xforum142riidax in forum Excel General
    Replies: 7
    Last Post: 09-11-2012, 04:38 PM
  2. Dollars to hours and minutes
    By mdieckmeyer in forum Excel General
    Replies: 2
    Last Post: 10-31-2011, 08:59 PM
  3. dollars/cents multiplied by hours/minutes or tenths
    By JiggsTiger in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-30-2006, 08:10 AM
  4. Replies: 1
    Last Post: 12-12-2005, 02:45 PM
  5. Chart Different Types of Data-contains hours and dollars
    By dalezjc in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 03-28-2005, 05:58 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1