Steve - Do you actually have the raw data at the moment or do you have to go
get all that? If you already have it, then as long as you can put it in the
format that Julie suggested then the Pivot Table will do this for you in a
matter of minutes, literally.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"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