How to convert the Closed Duration field from Seconds to Hours

Version 1

    Details

    You want to convert a Closed Duration field from seconds to hours to display on the grid using the format ##:##:##:##. 


    Resolution

     

    1. Log in to the tenant with the Administrator role
    2. Go to Configure Application
    3. Go to Business Objects
    4. Select the Incident business object
    5. Go to Fields
    6. Create a new text field called ClosedDurationToText 
    7. Save
    8. Click on Business Rules
    9. Create a new Before Save Rule to set the new field with the following expression:  $(SecondsToTime(ClosedDuration))
    10. Add the new field to the Grid
    11. Save
    12. Refresh browser