none
Where do I find examples of how to use formula functions? Online help only provides syntax RRS feed

  • Question

  • Hello,

    I would like to run a formula ( for my custom field in Project 2013)  that allows me to see the Finish Time e.g. 17:15 for a task.  I am trawling through the online help to determine which one is best but I would like to read some examples of how a function can be used. I hoped Help may do this but no.

    Hope you can point me into the right direction.  Thanks in advance.

    Alan

    Sunday, April 12, 2015 2:11 PM

Answers

  • Alan,

    Yeah I agree, the on-line help is lacking in information on how to actually USE a function. However, there are some places that may help. Here are a couple, I'm sure there are many others.

    https://support.office.com/en-nz/article/Project-functions-for-custom-fields-7e525143-380f-4083-8d5a-3ecc6ba44f22

    https://msdn.microsoft.com/en-us/library/office/ee767700(v=office.14).aspx

    Since many of the custom field formulas are also used in VBA, I've found the object library reference for VBA to be very helpful in understanding and setting up custom field formulas. To get the the object library, go to Developer/Code group/Visual Basic. Once the Visual Basic Editor window opens, hit View/Object Browser. Hit the Help menu and select the Help for Visual Basic. Type in the function of interest.

    However, you say you want a custom formula to see the finish time for a task. You don't need any customization to see that. Simply go to File/Options/General tab and select a date format that includes the time.

    Hope this helps.

    John

    • Marked as answer by Alan.M.Purvis Sunday, April 12, 2015 4:54 PM
    Sunday, April 12, 2015 4:01 PM

All replies

  • Alan,

    Yeah I agree, the on-line help is lacking in information on how to actually USE a function. However, there are some places that may help. Here are a couple, I'm sure there are many others.

    https://support.office.com/en-nz/article/Project-functions-for-custom-fields-7e525143-380f-4083-8d5a-3ecc6ba44f22

    https://msdn.microsoft.com/en-us/library/office/ee767700(v=office.14).aspx

    Since many of the custom field formulas are also used in VBA, I've found the object library reference for VBA to be very helpful in understanding and setting up custom field formulas. To get the the object library, go to Developer/Code group/Visual Basic. Once the Visual Basic Editor window opens, hit View/Object Browser. Hit the Help menu and select the Help for Visual Basic. Type in the function of interest.

    However, you say you want a custom formula to see the finish time for a task. You don't need any customization to see that. Simply go to File/Options/General tab and select a date format that includes the time.

    Hope this helps.

    John

    • Marked as answer by Alan.M.Purvis Sunday, April 12, 2015 4:54 PM
    Sunday, April 12, 2015 4:01 PM
  • Thanks John,

    The object library link is certainly the most relevant to my question. Thank you.
    I was aware of the General tab option but that applies to all dates. I wanted to focus on the Finish Time in particular and not apply to all my dates to be longer date format.  So my idea was to create a new custom with just the time extracted from Finish.  I was considering a string conversion or some route like that.

    Thanks for your reply

    Alan

    Sunday, April 12, 2015 4:58 PM
  • Alan,

    You're welcome and thanks for the feedback.

    Okay, now it makes sense that you want a custom field. Here's the formula I came up with in the Text1 field:

    Format([Finish],"m/d/yy h:mm")

    John

    Sunday, April 12, 2015 8:14 PM