Create a Custom Field that Displays the Time Difference between End Time and Start Time on a Phone Call Record

To create a custom field that can show the difference between the End Time and Start Time on a Phone Call record, perform the following steps:

    1. Navigate to Customization > Lists, Records, & Fields > CRM Fields > New.

    2. Provide a Label (e.g. Duration).

    3. Set Type to Free-Form Text.

    4. Set Store Value to No.

    5. In the Applies To tab, check Phone Call.

    6. In the Display tab, set Subtab to Main and Display Type to Inline Text.

    7. In the Validation and Defaulting tab, set Default Value to:

    EXTRACT (HOUR FROM (to_timestamp(to_char ({endtime}, 'HH24:MI'), 'HH24:MI') - to_timestamp(to_char ({starttime}, 'HH24:MI'), 'HH24:MI'))) || ':' || EXTRACT (MINUTE FROM (to_timestamp(to_char ({endtime}, 'HH24:MI'), 'HH24:MI') - to_timestamp(to_char ({starttime}, 'HH24:MI'), 'HH24:MI')))

    8. Check Formula.

    9. Click Save.