• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Convert Hours to Working days

    I realize this is probably very easy but I'm stumped and can't figure it out. In excel, I have hours in a h:mm format. I can easily change formats to dd:h:mm , but can't figure out the best way to convert this to working days (8 hour) i.e. [wd:h:mm]. Any help would be appreciated.
  2. M

    Help with formula comparing dates

    I'm trying to compare two dates in a Table to count the number of on time delivery of External requests. To accomplish this, my idea was to simply compare each record and count the number of times the Due Date > Date Sent. In theory, this should tell me if the deliverable was sent before the due...
  3. M

    Project Portfolio Dashboard VBA

    1) On the Dashboard Page, I wanted a better way to draw attention to a Project Budget if the Project Budget had gone "over-budget". Therefore, I added Conditional Formatting to the Budget Number to Turn Red when the Money Spent was greater than the budgeted amount on the Project Details page...
  4. M

    Detailed Project Portfolio - % Complete

    I am looking for any suggestions on a slight modification to the Detailed Project Portfolio dashboard. I am looking for a better way to report % Complete on a project as a way to measure Project Performance. What I would really like to be able to do is calculate Schedule Performance Index (SPI)...
Back
Top