| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Evaluating a start and an end date
I have a spreadsheet that emulates Microsoft Project where the first column
has the activities and the hours go across in the columns, by month. The engineers have already time phased each line item activity and now I need to calculate the start date and the end date for each activity based on where the time phased hours are placed (in what month). I'm assuming that all activities that have hours are contiguous hours. Start End Apr-08 May-08 Jun-08 Activity A ???? ??? 150hrs 120hrs 10hrs Activity B€¦. If at all possible, Id like to resolve this without VB€¦.but lets see what you folks can come up with. Thanks in advance€¦.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determining an annual review date from an employee start date | Excel Worksheet Functions | |||
| How to programatically determine the start date and end date of a graph | Charts and Charting in Excel | |||
| Minimum Date Greater Than Observation Start Date | Excel Discussion (Misc queries) | |||
| Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
| how do I do a Planned vs Actual start date & end date graph | Charts and Charting in Excel | |||
Threaded Mode
