Skip to main content

Notifications

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

Custom Calculated Duration Field

Posted on by 30

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.

 

pastedimage1665117912998v1.png

 

pastedimage1665117912999v2.png

 

pastedimage1665117912999v3.png

 

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.

pastedimage1665117913000v4.png

 

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

 

pastedimage1665117913000v5.png

 

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

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Custom Calculated Duration Field

    Hi Kimberly Claire Mata,

    I mean I have two Date time column input

    1. IN 
    2. 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/.../

  • RE: Custom Calculated Duration Field

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

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Custom Calculated Duration Field

    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 

    1. IN
    2. OUT

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

    In the first column, I calculated the minutes

    pastedimage1665119388658v1.png

    In the second column, I calculated the hours

    pastedimage1665119438622v2.png

    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/.../

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans