first of all i'm learning tings
I will ENTER 7.5 days in cell A1 (will show 7.5 )
then in cell B 1 will enter the start date and time of project lets say( 8/22/11 3:00 pm)
then C1 will give me the answer,when I add A1 & B1 but I want it to show me the date and time of the 7.5 days BUT IT HAS TO SHOW ME THE WORK DAYS ONLY (NO WEEKEND DATES ADDED)
on a 24 hr workday M TO F
then in D1 I will enter the real finish date BUT 10 DAYS LATER
( 2.5 DAYS PAST DUE DATE OF CELL C1)
so in cell E1 i want to subtract. start day (B1) from finish REAL finish date 9/5/11 9:45 pm (D1) in work days
giving me the answer to the total days project ran in work days
i can do the cells but i'm lost becouse the hrs do not matchwhen it come to the .5 daysor if i have a odd .2 days
Bookmarks