Skip to main content

Notifications

Microsoft Dynamics CRM forum
Suggested answer

duration tracking for each stage in tasks

Posted on by 160

Hi everybody,

I have a case in one project and i want to see the amount of time in which state a task was, till it is completed. I have this field on the task entity: 

4aaae4cd_2D00_4684_2D00_4791_2D00_af7a_2D00_c8330ef0ec50.png

When a task is set to a status "Not Started", "In Progress" or "Waiting on someone else" the fields should be calculated in hours and minutes for how long they were in this status. 

Does anybody have an Idea how to implement it best? Does a calculated field help me solve this problem?

Thank you in advance!

Best Regards

  • kunihih Profile Picture
    kunihih on at
    RE: duration tracking for each stage in tasks

    Hello Elpibato

    I think you need the separate the two time parameter values with a comma and not a minus sign.

    ie.   DIFFINHOURS(NOW(), tv_timetochangestatus)

    docs.microsoft.com/.../define-calculated-fields

  • Elpibato Profile Picture
    Elpibato 160 on at
    RE: duration tracking for each stage in tasks

    Hi Kunihiko,

    Thanks for your suggestion!

    Thanks!!

  • Suggested answer
    kunihih Profile Picture
    kunihih on at
    RE: duration tracking for each stage in tasks

    The following is my suggestion:

    1. Create a field that will hold the time at which the Status Reason was changed.

    2. Create a workflow that will set this field to the current time whenever the Status Reason is altered.

    3. Create a calculated field that will display the difference between the current time and the value found in the field created/set in steps 1 and 2.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans