Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
"='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4 | Excel Worksheet Functions | |||
create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |