none
Custom Flag field - if Baseline Work exceeds a certain duration RRS feed

  • Question

  • Wondering if this can be done. I'd like to see that all tasks where the baseline duration exceeds 14 hours sets off a flag, so that we're able to split it into sub-tasks. Thanks!
    Tuesday, October 27, 2015 4:40 PM

Answers

  • Karen,

    Sure, no problem. You need to know that Project stores all time based data in minutes, so even though the display may show duration values in hours or days, when you do a test for a duration value, you must do that test in minutes. The following formula in the Flag1 field will do what you want (14h x 60 min = 840).

    Flag1=IIf([Baseline Duration]>840,True,False)

    Hope this helps.

    John

    • Marked as answer by Karen Rolling Tuesday, October 27, 2015 8:26 PM
    Tuesday, October 27, 2015 6:01 PM

All replies

  • Karen,

    Sure, no problem. You need to know that Project stores all time based data in minutes, so even though the display may show duration values in hours or days, when you do a test for a duration value, you must do that test in minutes. The following formula in the Flag1 field will do what you want (14h x 60 min = 840).

    Flag1=IIf([Baseline Duration]>840,True,False)

    Hope this helps.

    John

    • Marked as answer by Karen Rolling Tuesday, October 27, 2015 8:26 PM
    Tuesday, October 27, 2015 6:01 PM
  • Thanks John, this worked perfectly. 

    Tuesday, October 27, 2015 8:26 PM
  • Karen,

    You're welcome and thanks for the feedback.

    John

    Tuesday, October 27, 2015 8:39 PM