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.
February 22, 2008 2:11 AM
February 22, 2008 1:18 PM