tb, 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
"tb" wrote in message
...
I am looking for 8 hours a day at regular then a column for this total.
anything above 8 hours is 1.5 - then a column for this total.
then a column for total to be paid.
Basically a breakdown of regular pay, overtime pay and then total pay.
Thanks
t
"tb" wrote:
I want to setup a time sheet for 20+ employees, with the breakdown of
regular
and overtime hours with calculations weekly.
I currently have a weekly time sheet with all employees, hours they
worked
daily for the week, then a column that totals all the hours and
calculates
the total with their wage.
I need some formulas to help me setup a column that will calculate over
and
beyond for o.t. hours then add all totals together.
Am I asking for to much? I did play and set one worksheet up but it is
pretty complex. Is there possibly some samples or templates I can look
at? I
did look in office templates but nothing I am really looking for.
Thanks
t