Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to seperate OT and Reg. Hours from total hours
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. |