payroll

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

Thanks Paul. I think thats what I am looking for. I can figure it out from
here.
Thanks again,
Bill
"Paul B" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>
>

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

"william forbes" <[email protected]> wrote in message
news:[email protected]...
> Thanks Paul. I think thats what I am looking for. I can figure it out from
> here.
> Thanks again,
> Bill
> "Paul B" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> >> 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
> >>
> >>
> >
> >
>
>