Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Calculate Duration of Time in Specific Case Status

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

In our system a case can be in various statuses, "In Progress" being one of them. I would like to be able to calculate the time that the job is in the "In Progress" status only but haven't been able to find a clear method to do that.

I have researched the out-of-box Timer in the CRM but it seems to be a countdown timer without much customization available. Any suggestions? Thank you!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Calculate Duration of Time in Specific Case Status

    If you look at above example we need exclude after hours and week end while calculating Datediff

  • Suggested answer
    Temmy Wahyu Raharjo Profile Picture
    Temmy Wahyu Raharjo 2,914 on at
    RE: Calculate Duration of Time in Specific Case Status

    The easiest way is you create new attribute to store the start time, then when they solved the case, you just calculate the end time - start time (new attribute) that one.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Calculate Duration of Time in Specific Case Status

    Hi guys

    Configuring SLA Timers in Dynamics CRM

    Is there a way to save the timer value in CRM so that i know how much time it took to resolve a Case.

    Eg if a case come on friday eve at 4 30 and get resolved at Monday morning at 10 am. Assuming our office hours is from 9 to 5 pm. Can i get a time to count 90 mins and save that in crm for that case. I know we can assign business hours to SLA entities and start times depending upon its sucess condition but still couldn't figure out how to grab value of timer and save it.

  • Suggested answer
    PS Profile Picture
    PS 23,577 on at
    RE: Calculate Duration of Time in Specific Case Status

    Refer this URL: prashantshuklacrm.wordpress.com/.../calculating-time-spent-in-minutes-on-an-activity-via-javascript-in-ms-crm-2015

    Just add your status specific conditions

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Calculate Duration of Time in Specific Case Status

    I read through the article and tried implementing it but still having issues. Wouldn't an SLA still be a countdown timer rather than a timer that calculates time elapsed?

  • ThomasN Profile Picture
    ThomasN 3,190 on at
    RE: Calculate Duration of Time in Specific Case Status

    Hi Brian,

    Thanks for reaching out. Just wanted to support Abed, using the SLA is the easiest way to do this.

    -Tom

  • Suggested answer
    Abed Haniyah Profile Picture
    Abed Haniyah 4,285 on at
    RE: Calculate Duration of Time in Specific Case Status

    You can use SLA to achieve this, refer to : Guide to Managing Service Level Agreements with Dynamics CRM

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans