| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formulating Different Start/Finish Dates with Man Hours
I need help with this and hopefully someone can assist! I am working with a
spreadsheet that has different start and finish dates during the fiscal year (Oct - Sept). There are man hours associated with each person and their availability. HOW CAN I FORMULATE TO SHOW THE # OF PEOPLE ASSOCIATED & AVAILABLE AS A RESOURCE WITH EACH UNIQUE TIME PERIOD????? Example: Name Start Finish Hrs/Wk 2nd dates hrs/wk Person A 10/1/07 - 9/30/11 40 Person B 10/1/07 - 8/4/08 40 8/4/09 - 9/30/11 40hrs Person C 5/30/09 - 9/30/11 40 Person D 2/11/08 - 8/15/09 20 9/10/10 - 9/30/11 20hrs -- DB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| start finish dates | Excel Discussion (Misc queries) | |||
| Calculate working hours from a start and finish time over several | Excel Worksheet Functions | |||
| Getting no of hours from start to finish | Excel Discussion (Misc queries) | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| How do I chart date ranges with varying start and finish dates? | Charts and Charting in Excel | |||
Threaded Mode
