Thread: 1st sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tia[_3_] Tia[_3_] is offline
external usenet poster
 
Posts: 79
Default 1st sheet

Hi
I am working on a workbook with identical sheets formats for a project
costing what i need is a summary sheet that allows me to know the
total of working hours for each project and the total of working time
for each project by each employee
the workbook cotain 12 sheets each month one sheet is added in the
same format but with more projects the format is this way

A B
C D
1 Project Name Employee listing
2 George
John Pamela
3 United Tower 100
10 50
4 UK Bridge 0
150 20


Each month a new sheet with more projects to be added and more
employees sometimes

What i need is a summary sheet that calculates the total of worked
hours pr employee for each project in order to have the costing

Thank you in advance
Tia