Closed Thread
Results 1 to 18 of 18

Planned vs Actual Formula

Hybrid View

juan.doe Planned vs Actual Formula 07-15-2014, 12:21 AM
benishiryo Re: Planned vs Actual Formula 07-15-2014, 12:29 AM
juan.doe Re: Planned vs Actual Formula 07-15-2014, 12:37 AM
FDibbins Re: Planned vs Actual Formula 07-15-2014, 01:20 AM
juan.doe Re: Planned vs Actual Formula 07-18-2014, 01:08 AM
juan.doe Re: Planned vs Actual Formula 07-18-2014, 01:25 AM
Punnam Re: Planned vs Actual Formula 07-18-2014, 03:02 AM
juan.doe Re: Planned vs Actual Formula 07-18-2014, 10:09 AM
Punnam Re: Planned vs Actual Formula 07-18-2014, 12:35 PM
juan.doe Re: Planned vs Actual Formula 07-19-2014, 12:37 AM
Punnam Re: Planned vs Actual Formula 07-19-2014, 02:21 AM
juan.doe Re: Planned vs Actual Formula 07-21-2014, 07:12 AM
Punnam Re: Planned vs Actual Formula 07-22-2014, 01:11 AM
juan.doe Re: Planned vs Actual Formula 07-22-2014, 11:05 PM
Punnam Re: Planned vs Actual Formula 07-22-2014, 11:23 PM
Real_Madrid Re: Planned vs Actual Formula 04-30-2021, 09:16 AM
Real_Madrid Re: Planned vs Actual Formula 05-01-2021, 06:01 AM
AliGW Re: Planned vs Actual Formula 05-01-2021, 07:27 AM
  1. #1
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: Planned vs Actual Formula

    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
    Attached Files Attached Files

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. A Schedule with Planned, Actual, Days +/- and Future Dates
    By jm90045 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-28-2013, 08:16 PM
  2. Traffic Light for Hours / Days actual vs planned
    By JPD in forum Excel General
    Replies: 4
    Last Post: 06-08-2011, 10:21 AM
  3. Planned vs. Actual Gantt
    By mycon73 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-22-2011, 01:10 AM
  4. Excel 2007 : Gathering Planned and Actual hours
    By Kburtt in forum Excel General
    Replies: 0
    Last Post: 02-28-2011, 10:42 PM
  5. Conditional Formating planned VS actual date
    By rhatala@stny.rr.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-02-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1