• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculating pay using different penalty rates within the same shift


New Member
Hi there :)

Is there any ideas on formulas to help me streamline/calculate my gross pay per work shift when each shift might have 3 different penalty rates depending on the time of the shift e.g. Sunday night shift starting at 2300 and ending 0700 on Monday morning encompasses 3 pay scales, one for 11pm - midnight on Sunday, one for midnight to 6am Monday and one for 6am - 7am Monday morning.

Can excel look up a date and time (maybe start time of the shift since each is 8 hours) and then determine which pay scale should be applied for the relevant times within that shift?

Hope that makes sense? Any help would be sooooooo appreciated :)


Excel Ninja
As a new member,
reread Forum Rules
especially part
How to get the Best Results at Chandoo.org
and after that
You'll re-remember what have You missed to get results.