How to seperate OT and Reg. Hours from total hours
Thank you for your help.
If I would like to enter in daily hours worked over a five day work week and
have Excel seperate and sum the Regular hours and OT hours, how can I do that?
"cmc1111" wrote:
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.
|