Service | Customer Service, Contact Center, Fie...

Custom Calculated Duration Field

(0) Share

Report

Posted on by Kimberly Claire Mata

Hi Rhipe Support,

I created a custom duration field where it does not include the travel duration. Like the main focus of the custom duration field is work duration only.

Below are the different formats that I tried.

I followed the steps provided here: https://learn.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/define-calculated-fields?view=op-9-1

This is the Action that we set up.

However, the calculation worked in the 3 custom fields, but it did not include the .5 hours or 30 minutes work time.

The second issue is the field is showing minutes instead of hours.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report
Hi Kimberly Claire Mata,

I was facing a similar issue when creating an application for the HR module. I had two input Date Time columns

IN

OUT

I created two Decimal type calculated columns to resolve this issue.

In the first column, I calculated the minutes

In the second column, I calculated the hours

I think you should need something similar.

If I answer your question then please mark it as verified.

Let me know if I can provide you with more details.

Thanks
Regards,

Abdul Wahab
Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: www.linkedin.com/.../

Was this reply helpful? Yes No
Kimberly Claire Mata 30 on at

Like (0)

Report

hi Abdul Wahab , what do you mean by "Two input Date Time columns", do you have 2 fields for that?

Was this reply helpful? Yes No
Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report
Hi Kimberly Claire Mata,

I mean I have two Date time column input

IN

OUT

I need duration in terms of hours and minutes. I tried using the duration format but I was facing similar issues... As I explained in my last answer, I fulfilled my requirement with the decimal columns...

If I answer your question then please mark it as verified.

Let me know if I can provide you with more details.

Thanks
Regards,

Abdul Wahab
Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: www.linkedin.com/.../

Was this reply helpful? Yes No