Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Getting duration between status changes

Avatar

Level 2

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,

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 2

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)