payroll

[william forbes]

Employee timecard (daily, weekly, monthly, and yearly)
I am using this template to track hours. I need to get it to start adding
overtime hours at 40. right now it just adds hours. can you help me with the
formula to get it to do this. It is a great template for me. Thanks, please
help.
Bill

 

[Paul B]

Bill, see if this will help, http://www.cpearson.com/excel/overtime.htm

--
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

 

[william forbes]

Thanks Paul. I think thats what I am looking for. I can figure it out from
here.
Thanks again,
Bill

 

[Paul B]

Your welcome

--
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