Microsoft Dynamics 365 | Integration, Dataverse...

DateDiff function

(0) Share

Report

Posted on by Muhammad Anas Naeemi

390

Hey community,

I have created a field "Resolution Time" that will be used for calculating the time between a issue created by the client and resolved by the employee using DateDiff(Issue Creation Date, Issue Close Date, TimeUnit.hours). So for e.g. if the issue is resolved in 5 days the resolution time will be 120 hours (5 days*24 hours). The thing is that employee only works for 8 hours a day. So the employee took 40 hours to resolve the issue and not 120 hours. How can I formulate that?

This formula I have created but it is not working accurately.

Like in the above case it should give 121 hours and 8 minutes in 24hours a day format and 41 hours and 8 minutes in 8hours a day format but its giving only 121 hours in 24hours a day format and 40.33 in 8hours a day format. Kindly suggest me the accurate formula for doing it. Thank you,

I have the same question (0)

All responses (7)

Answers (0)

Muhammad Anas Naeemi 390 on at

Like (0)

Report

You can also suggest me the formula resulting as 5 days 1 hour and 8 minutes for the above given time duration.

Was this reply helpful? Yes No
Suggested answer

Naveen Ganeshe 3,397 User Group Leader on at

Like (0)

Report

Hi Anas,

You can give it a try:

DateDiff(IssueCloseDate,IssueCreateDate,TimeUnit.Minutes) / 60 / 8

It will result in time in days

Was this reply helpful? Yes No
Muhammad Anas Naeemi 390 on at

Like (0)

Report

Hey Naveen it is not working. Can you show me code for displaying A days, B hours and C minutes

Was this reply helpful? Yes No
Suggested answer

Naveen Ganeshe 3,397 User Group Leader on at

Like (0)

Report
Here is a c# code. you can convert this
TimeSpan resolutionTime = issueCloseDate - issueCreationDate; int totalDays = (int)resolutionTime.TotalDays; int workingDays = totalDays - (totalDays/7)*2; int workingHours = workingDays * 8; int minutes = resolutionTime.Minutes;

Was this reply helpful? Yes No
Muhammad Anas Naeemi 390 on at

Like (1)

Report

Hey everyone, thank you everyone for the response. I have achieved my desired functionality.

Was this reply helpful? Yes No
Naveen Ganeshe 3,397 User Group Leader on at

Like (0)

Report

Good to hear that.

Was this reply helpful? Yes No
Suggested answer

Eiken on at

Like (0)

Report

Hi,

You can also create two new calculate field, one is calculate hours and another calculate minutes using DateDiff.

Then create a field using formula.

Was this reply helpful? Yes No