+ Reply to Thread
Results 1 to 5 of 5

normalizing hours based on new hourly rate

  1. #1
    Forum Contributor
    Join Date
    12-10-2012
    Location
    Petalu
    MS-Off Ver
    Excel 2010
    Posts
    140

    normalizing hours based on new hourly rate

    Happy new year everyone.
    I have an old hourly rate of $70/hour
    I have a new hourly rate of $100/hour
    My spreadsheet tracks my hours worked and revenue based on the old hourly rate. So I cant log 6 hours for this new client because then the total would be $420 ($70*6). Instead I need to put a formula that would calculate an adjustment of hours based on that old rate. The spreadsheet shows that $100/hour is a 42.9% increase over $70/hour, but what do I log for the hours worked in cell D11 to normalize that rate?
    Attached Files Attached Files
    Last edited by TheVolkinator; 12-29-2019 at 04:32 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: normalizing hours based on new hourly rate

    Hi
    your thread has null answers but nonetheless indicated as " Solved" . Is this correct?

  3. #3
    Forum Contributor
    Join Date
    12-10-2012
    Location
    Petalu
    MS-Off Ver
    Excel 2010
    Posts
    140

    Re: normalizing hours based on new hourly rate

    Correct i figured it our thanks

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: normalizing hours based on new hourly rate

    Great.
    Care to share the solution with the board when you have a moment?

  5. #5
    Forum Contributor
    Join Date
    12-10-2012
    Location
    Petalu
    MS-Off Ver
    Excel 2010
    Posts
    140

    Re: normalizing hours based on new hourly rate

    I actually just changed the format of the spreadsheet and included the hours directly so there was no need for a formula

+ 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. Total not adding up from hours total and hourly rate.
    By Spitfire147 in forum Excel General
    Replies: 1
    Last Post: 10-07-2019, 02:53 PM
  2. Replies: 6
    Last Post: 01-18-2019, 03:29 PM
  3. multiply hours by hourly rate
    By Stu100 in forum Excel General
    Replies: 2
    Last Post: 07-10-2011, 04:51 PM
  4. How do i multiply an hourly rate by hours in Excel?
    By Rackenford. in forum Excel General
    Replies: 2
    Last Post: 07-02-2006, 10:55 AM
  5. Hourly rate times hours?
    By L in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-08-2006, 01:35 PM
  6. [SOLVED] how do I calculate hours spent x an hourly rate?
    By JC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2006, 12:35 PM
  7. Calculation of hourly rate times hours times 1.5
    By Newbusinessbod in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-06-2005, 12:50 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