After 5pm employees get paid a different rate per hour.
Currently 4 entries for time "in" and "out" before and after lunch.

Need to have Excel determine that after lunch, say, "1:45pm"-"6:15pm"
includes 1.25 hour AFTER 5pm and needs to apply a different pay rate to that
1.25 hrs.

I really don't want to have to add an extra 3 cells to the equation
from"Clock in from lunch" to "4:59 PM" and "5:00 PM" to "Clock out for the
day".

Office 2007 Ulitmate Excel
Win7 64bit