+ Reply to Thread
Results 1 to 8 of 8

Calculating regular hours based on to 2 different pay Rates

  1. #1
    Registered User
    Join Date
    11-23-2019
    Location
    United States
    MS-Off Ver
    Microsoft Office 365
    Posts
    14

    Calculating regular hours based on to 2 different pay Rates

    I am trying to figure out a formula for calculating regular hours based on 2 different pay rates within the same week.
    Ex. On 11/20/2019 the pay rate is $12.50 and I worked 4:00pm - 2:30am which is equal to 10.5 hours. The total pay for that day would be 12.50*10.5 which equals 131.25. Now, lets say they raise the pay rate to $16.50 on 11/21/2019 and stays that rate for the rest of the time. And for that day I worked 4:00 pm - 2:30am again with 10.5 hours. The pay for that day would be $173.25. So I set up a formula for regulars meaning up to 40 hours. The question I have now is, how would you calculate the total pay with the total hours I have right now, which is 21 hours to the different pay rates? Would you use the 12.50 or the 16.50? Or Both? If both, then how would you formulate it?
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Calculating regular hours based on to 2 different pay Rates

    Welcome to the forum.

    How is Excel meant to know which days are to be paid at holiday rates? I see no indication in the workbook. Like us, Excel is not clairvoyant, so you need to give it a helping hand.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    11-23-2019
    Location
    United States
    MS-Off Ver
    Microsoft Office 365
    Posts
    14

    Re: Calculating regular hours based on to 2 different pay Rates

    The holiday pay rate starts on the Nov. 21st, 2019 and remains that rate until it is over.

  4. #4
    Forum Contributor
    Join Date
    08-07-2018
    Location
    india
    MS-Off Ver
    2007
    Posts
    233

    Re: Calculating regular hours based on to 2 different pay Rates

    HI CLEAD,
    may be this is what you want. i have just tried to answer your question as much i could understand that. please see if that can fulfills your requirements.
    have a nice day.
    Attached Files Attached Files

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Calculating regular hours based on to 2 different pay Rates

    Quote Originally Posted by Clead23 View Post
    The holiday pay rate starts on the Nov. 21st, 2019 and remains that rate until it is over.
    OK - and when is it over?

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Calculating regular hours based on to 2 different pay Rates

    Quote Originally Posted by akshay6s View Post
    HI CLEAD,
    may be this is what you want. i have just tried to answer your question as much i could understand that. please see if that can fulfills your requirements.
    have a nice day.
    Sorry for off-topic interjection:

    Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

  7. #7
    Registered User
    Join Date
    11-23-2019
    Location
    United States
    MS-Off Ver
    Microsoft Office 365
    Posts
    14

    Re: Calculating regular hours based on to 2 different pay Rates

    Holiday pay is over on 12/20/2019.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Calculating regular hours based on to 2 different pay Rates

    Did the suggestion in post #4 suit you?

+ 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. Replies: 3
    Last Post: 12-08-2020, 12:22 PM
  2. [SOLVED] Timesheet Day hours Night hours Nght Rates Overtime rates
    By viper8283 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-13-2018, 06:47 PM
  3. Calculating regular/overtime hours
    By shawdowheart in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-20-2014, 11:22 AM
  4. Calculating Regular Hours and OT in Timesheet
    By z0rd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2013, 11:27 AM
  5. Replies: 2
    Last Post: 07-27-2012, 04:54 AM
  6. Calculating wages from hours worked and hourly rates?
    By mathrocks in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-13-2010, 03:22 AM
  7. Replies: 0
    Last Post: 08-23-2005, 12:33 PM

Tags for this Thread

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