Getting duration between status changes | Community
Skip to main content
H
HectorMe2
Level 2
April 29, 2020
Question

Getting duration between status changes

  • April 29, 2020
  • 1 reply
  • 600 views

I am trying to capture the time between status changes, and what I have is very hit and miss right now.

I am able to collect when the task goes IP and Complete. But when I try to do the calculations thats when the fun happens. I either get a fractional hour or a big fat zero.

Capture IP timestamp Date and Time Format:

  • In Progress Status Timestamp Field: IF(Status='INP',IF(ISBLANK(In Progress Status Timestamp),$$NOW,In Progress Status Timestamp),In Progress Status Timestamp)

Completion Timestamp: Date and Time Format

  • Complete Status Timestamp: IF(Status='CPL',IF(ISBLANK(Complete Status Timestamp),$$NOW,Complete Status Timestamp),Complete Status Timestamp)

Duration Field: Number Format

  • Duration Between In Progress and Complete Statuses: ROUND(WORKMINUTESDIFF(Complete Status Timestamp,In Progress Status Timestamp)/60,2)

Task that have ranges from 1 to 3 min show zero, if they do show, 5 min task show .08. I have removed the "/60,2" in various tries with no luck. Like I said now most of the time I get a 0 reported.

Second part to this would there be any way to capture this data, over and over? Right now it looks like this is a one time capture. I am looking for something similar to what is shown with "Getting timestamp from status changes" solution?

Thanks,

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    H
    HectorMe2Author
    Level 2
    May 6, 2020

    So after talking to someone at workfront, changing the 60 to 1 gives me the time minutes

    Duration Field: Number Format

    • Duration Between In Progress and Complete Statuses: ROUND(WORKMINUTESDIFF(Complete Status Timestamp,In Progress Status Timestamp)/1,2)

      Terms & ConditionsAccessibility statement

      Loading footer...