Hi Steve

personally, i'ld set up the workbook as follows
...............A...........................B...... ........C........D............E...............F... ..................G
1..Emp First Name...Emp Last Name...Dept...Date...Reg Hrs....Ot
Hrs.......Dbl Ot Hrs

and list the information down the worksheet. I would put all employees on
one sheet.

Then to extract the weekly, monthly, annual & dept information i would use a
pivot table. Check out
www.contextures.com/tiptech.html
for how to use pivot tables and what you can do with them

Cheers
JulieD


"Steve j." wrote in message
...
I need some help!! I have been teaching myself how to use Excel, and I am
getting there. Our company has 21 employees. I have to create a listing
that
will show the hours for each employee, regular, overtime and double
overtime.
It has to be able to show, weekly totals, quarterly totals, and annual
totals
for each employee, and a summary of the departments. I have no clue, how
to
start! I am sure there are time keeping software somewhere on line, but
that
would take the fun of trying to do it myself. Can someone point me in the
right direction? How do I list the employees? How can I show each
employees
totals? Do I need separte worksheets for each employee? Any and all help
would be extremely appreciated.
--
Steve J