Shift Differential

20 pts.
Tags:
Microsoft Excel
Microsoft Excel 2003
How can I write a formula for shift differential if 06:00-14:00 is normal working, 14:00-22:00 is $1.00 more an hour and 22:00-06:00 is .90 more an hour? (A5 Work Hours ) (B5-Sunday start) (C5- Sunday End) (D5- Monday Start) (E5- Monday End) etc. Thanks you to any one that can help.

Answer Wiki

Thanks. We'll let you know when a new response is added.

The first question is what application are you trying to write this forumula in? Excel, SQL, Oracle, Access, DB2, etc?

The second question then becomes how are you storing your data. If you can include sample data that you are dealing with that will greatly help the process along.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Bradyman699
    I'm using excel 2003. This is my 1st time on this site. I'm not sure how to include a sample.
    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: