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 mean I have two Date time column input
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/.../
hi Abdul Wahab , what do you mean by "Two input Date Time columns", do you have 2 fields for that?
I was facing a similar issue when creating an application for the HR module. I had two input Date Time columns
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/.../
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156