Home > IT Answers > Microsoft Windows > Shift Differential
Bradyman699
20 pts.
 Shift Differential
Excel 2003, Microsoft Excel
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.

Software/Hardware used:
ASKED: February 22, 2008  2:11 AM
UPDATED: February 22, 2008  1:18 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  February 22, 2008  2:33 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I’m using excel 2003. This is my 1st time on this site. I’m not sure how to include a sample.

Bradyman699
 20 pts.