| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a function that separates over-lapping work shift hours. | Excel Worksheet Functions | |||
| List employees with hours worked, weekly, quarterly, and annually | New Users to Excel | |||
| calculate hours just can't figure it out | Excel Worksheet Functions | |||
| looking for template to track hours on projects for employees | Excel Discussion (Misc queries) | |||
| Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
Linear Mode
