I am setting up an employee spread sheet for tracking and billing hours
worked. What I would like to do is enter the total daily hours an employee
works and have Excel seperate and quantify both regular hours and OT hours.
What function can I use to sum daily hours equal to or less than 8 hours, and
sum everything over 8 hours seperately.