Hi,
1) Multiplication with 8 hour in a day for the plan effort in summary sheet
2) #Value are generated due to data in Plan Effort sheet i observed that some cells are showing blank but having " " (i.e (Space) i have to be identified and remove manually by Replace command .
3) I have corrected the formula to match u r requirement .
Punnam
Bookmarks