How to seperate OT and Reg. Hours from total hours
Would have helped if I had put in the link :(
It was the same as Gord's
--
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
"Paul B" wrote in message
...
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.
|