Premium Excel Course Now Available!

Build Professional - Unbreakable - Forms in Excel

45 Tutorials - 5+ Hours - Downloadable Excel Files

Instant Access! - Lifetime Access!
View Course

User Pay Differential

Macros, VBA, Excel Automation, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at

User Pay Differential

Postby bcarroll76 » Wed Jan 18, 2017 7:11 pm

Good afternoon everyone, I have an odd shift differential computing question....

Our staff get a shift differential of $3 per hour if more than half of their shift is worked between 3pm - 11pm and they get $10 per hour extra if they work more than half of their scheduled shift between 11pm and 7am. Also, this shift diff needs to be divided by the half hour and again by the # of sites they are supporting (reflected as "PART" in table)

I have my spreadsheet completed that computes everything and this is the only thing left to add.. I have attached the schedule sheet and the table data produced from my script and macros...

I am hopeful this is a formula that can be added to the table instead of a different sheet if at all possible. But, anything would work at this point.

Thank you!
  • 0

You do not have the required permissions to view the files attached to this post.
Posts: 1
Joined: Jan 18, 2017
Reputation: 0
Excel Version: 2013

Re: User Pay Differential

Postby NoSparks » Fri Jan 20, 2017 2:36 pm

What happened after post #57 ?
  • 0

Excel Hobbyist
Posts: 637
Joined: May 28, 2014
Reputation: 103
Excel Version: 2010

Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot] and 7 guests