Extracting/Inserting Lag time from/to Predecessors/Successors

[Nurazhar]

Hi,

How do I extract the lag time from predecessors/successors and display it in
a customized column? Vice versa will be inserting the duration from a
customized column to be the lag time of a predecessor/successor? I have
looked through the Text formulas, but I can't seem to find one which can
take a character '[' as it's start point of extracting the text.

Appreciate the help. Thanks in advance!

Sincerely,
Nurazhar

 

[Rod Gill]

Hi,

The text Instr function will return the starting position of one string in
another, EG:

Mid([Text1],instr([Text1],"[")) to return all text after and including the
"[".

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Nurazhar]

Hi,

Got it. That works nicely. But is it possible to insert a value into the
predecessor? e.g: I have a column "Days ahead of Deadline", and users will
be editing this column to modify the lag time instead of directly from the
Predecessor column.


Sincerely,
Nurazhar

Hi,

The text Instr function will return the starting position of one string in
another, EG:

Mid([Text1],instr([Text1],"[")) to return all text after and including the
"[".

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Hi,

How do I extract the lag time from predecessors/successors and display it
in a customized column? Vice versa will be inserting the duration from a
customized column to be the lag time of a predecessor/successor? I have
looked through the Text formulas, but I can't seem to find one which can
take a character '[' as it's start point of extracting the text.

Appreciate the help. Thanks in advance!

Sincerely,
Nurazhar

 

[Rod Gill]

You can't enter a formula in anything but a custom field, so no. You can
however write some VBA code to calculate and copy data to a predecessors
column.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Hi,

Got it. That works nicely. But is it possible to insert a value into the
predecessor? e.g: I have a column "Days ahead of Deadline", and users will
be editing this column to modify the lag time instead of directly from the
Predecessor column.


Sincerely,
Nurazhar

Hi,

The text Instr function will return the starting position of one string
in another, EG:

Mid([Text1],instr([Text1],"[")) to return all text after and including
the "[".

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Hi,

How do I extract the lag time from predecessors/successors and display
it in a customized column? Vice versa will be inserting the duration
from a customized column to be the lag time of a predecessor/successor?
I have looked through the Text formulas, but I can't seem to find one
which can take a character '[' as it's start point of extracting the
text.

Appreciate the help. Thanks in advance!

Sincerely,
Nurazhar