+ Reply to Thread
Results 1 to 2 of 2

Formula for rate of pay at different time of the day

  1. #1
    Registered User
    Join Date
    08-04-2016
    Location
    Manchester
    MS-Off Ver
    2016
    Posts
    1

    Question Formula for rate of pay at different time of the day

    Hello,

    I am having some trouble with the way to calculate the weekly wage basing on the hours worked with different rates of pay at different time of the day.

    Basically what I want is to enter my duties start and finishing times for the whole week (sunday to saturday) so that it calculates my income for the week basing on the hours including.
    However we have different rates of pay depending on the day and the time of the day

    Lets say :

    Basic rate of pay : 11
    ---
    Friday rate of pay: 11
    Friday evening rate of pay(8pm - 12am) : 12
    Friday night rate of pay(12am - 4am): 13
    ---


    This obvieously goes on for saturday and sunday but lets keep its simple, one formula will be enough help for me.

    Now lets say I start my work at 6pm(18:00) and finish at 10pm(22:00)
    This gives me 4 hours of work of which 2 hours are at $11 and 4 hours are at $12.

    The easy way would be to calculate how much hours and minutes I have worked at basic rate and times that by the rate and same again with the hours and minutes worked at higher rate. However this can be done using pen and paper but I want excell to do it without me having to enter the hours and minutes for different rates.

    Please help it would be very useful and helpful..

    Thankyou :*

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Formula for rate of pay at different time of the day

    Hi MissieK and welcome to the forum.

    but lets keep its simple, one formula will be enough help for me.
    This might be over simplified, but I will start here.

    There is a lookup table in columns E:F of the attached.

    In column A some times. Then in column B this formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Does this get you closer?
    Dave

+ 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. [SOLVED] Formula for Vacation Time Max Accrual Rate
    By brad.freeman in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-29-2021, 12:17 PM
  2. [SOLVED] Time Sheet Formula - different rate at different times
    By toxic27 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-10-2020, 08:08 AM
  3. Time Sheet Formula - different rate at different times
    By ZeRoo_ in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-24-2014, 10:15 AM
  4. Replies: 2
    Last Post: 01-30-2013, 01:04 AM
  5. Formula to display special hourly rate for part time employee...
    By matty88 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-30-2012, 11:28 AM
  6. Time * Rate = Amount Billed Formula?
    By Andrew Eagles in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-14-2006, 05:55 PM
  7. [SOLVED] Time * Rate = Amount Billed Formula?
    By Andrew Eagles in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-12-2006, 01:36 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