web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Calculate Duration of ...
Microsoft Dynamics CRM (Archived)

Calculate Duration of Time in Specific Case Status

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    Abed Haniyah Profile Picture
    Abed Haniyah 4,287 on at

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

  • ThomasN Profile Picture
    ThomasN 3,190 on at

    Hi Brian,

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

    -Tom

  • Community Member Profile Picture
    Community Member on at

    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?

  • Suggested answer
    PS Profile Picture
    PS 23,577 on at

    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 on at

    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
    Temmy Wahyu Raharjo Profile Picture
    Temmy Wahyu Raharjo 2,916 on at

    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 on at

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

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

#2
GJones Profile Picture

GJones 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans