cmc1111, have a look here for timesheet examples, there is also some or
links at the bottom, may even find one you can use :)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"cmc1111" wrote in message
...
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.