Results 1 to 9 of 9

Calculating penalty rates based on day of the week

Threaded View

  1. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,101

    Re: Calculating penalty rates based on day of the week

    add the dates into a column and then lookup to see if the date exists in the list

    you could use a table to look up the hourly rate - so that you can make any changes to that value without updating all the formulas
    see how i have added to pub hols
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formulas to Add shift penalty rates to specific times & days
    By sman1 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 03-26-2020, 11:24 PM
  2. [SOLVED] Formula for calculating a value based on tiered percentage rates
    By d_max_c in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-07-2014, 04:04 AM
  3. [SOLVED] Formula Help... Calculating charges based on stepped rates.
    By HoosierIT in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-23-2014, 05:55 PM
  4. Replies: 6
    Last Post: 05-16-2014, 11:30 AM
  5. Hi Everyone! Penalty Rates question right off the bat!
    By Szuperwoman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-17-2012, 01:29 AM
  6. calculating penalty rates
    By piaclaire in forum Excel General
    Replies: 6
    Last Post: 08-26-2010, 08:02 PM
  7. Replies: 1
    Last Post: 08-23-2005, 11:42 AM

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