employees hours
 

I have 50 employes that can work on upto 5 different jobs in a day or just
one . there hours and jobs are entered onto a excel chart so you can look at
one employe and see where he has worked all week. i want the information to
be printed out in a simple form so it can be easily entered into a paye
programme we use . it would have each man then his jobs and hours and it
would add the hours of same jobs worked more than once in a week and add them
up . make sense?

Hi, Karen. The feature is called Subtotals.
See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"karen" wrote in message
...
I have 50 employes that can work on upto 5 different jobs in a day or just
one . there hours and jobs are entered onto a excel chart so you can look
at
one employe and see where he has worked all week. i want the information
to
be printed out in a simple form so it can be easily entered into a paye
programme we use . it would have each man then his jobs and hours and it
would add the hours of same jobs worked more than once in a week and add
them
up . make sense?

sory but that function doesnt quite work as i have the information in grids
with blanks when they only worked on one job but next week might work on 4
jobs

"Anne Troy" wrote:

Hi, Karen. The feature is called Subtotals.
See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"karen" wrote in message
...
I have 50 employes that can work on upto 5 different jobs in a day or just
one . there hours and jobs are entered onto a excel chart so you can look
at
one employe and see where he has worked all week. i want the information
to
be printed out in a simple form so it can be easily entered into a paye
programme we use . it would have each man then his jobs and hours and it
would add the hours of same jobs worked more than once in a week and add
them
up . make sense?