Help in formatting a custom numbers field

Home Forums Microsoft Project Discussion Forum Help in formatting a custom numbers field

Viewing 3 reply threads
  • Author
    Posts
    • #5247
      Avatar photoCommunity
      Keymaster

      Following is my formatting problem:

      Task Mode Task Name Finish Finish1 Days
      Auto Scheduled Deployment 1.0 Tue 1/10/12 NA 4294926376.29
      Manually Scheduled Task 1 Mon 1/9/12 Tue 1/10/12 1.38
      Manually Scheduled Task 2 Tue 1/10/12 Wed 1/11/12 1

      The finish Fields are extracted from other project files. The Days field is a custom Number field that is calculated as follows:

      Finish1-Finish

      Can someone please help me in showing me how to format the “Days” column with zero decimal.

      Thanks for your help

    • #6962
      Avatar photoCommunity
      Keymaster

      Asim,

      I took a quick look at this – one possible quick fix could be adding the integer function to your formula:

      Int(Finish1-Finish)

      It returns the integer portion of a number.  I call this a quick fix because I think there are several ways you can have a decimal in this field and you might want to investigate further.  If there is a difference in the working times between the two different projects, this might be a cause.  You can show the time along with the date to see if one finish is at 5:00 and the other is at a different time (options/general/date format).

      Regards,

      Tim Jones

    • #6964
      Avatar photoCommunity
      Keymaster

      From memory, you can use a mixture of instr and left to find the number of characters to the left of the period (.) and then return the number of characters to the left of the (.)  this wouldn’t round it up, just truncate it.  A number field formats to 2 decimal places.

    • #6972
      Avatar photoCommunity
      Keymaster

      Pls try DateDiff( d”, [Finish, [Finish1] ) or the following to suppress “#ERROR” in case Finish1 contains no valid date value:

      IIf([Finish1]=ProjDateValue(“NA,0,DateDiff(“d”,[Finish],[Finish1]))

Viewing 3 reply threads
  • You must be logged in to reply to this topic.