How to calculate total time spent in DD:HH:MM format in Track-It! Report

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Track-It!


    COMPONENT:

    Track-It! 2019 R3


    APPLIES TO:

    All Web Based Track-It! versions



    QUESTION:

    How to calculate total time spent in DD:HH:MM format in Track-It! Report
     


    ANSWER:

    In order to obtain the Parent Category Folder,

       
    1. Add a calculated field to your report      
           
      • Click on the icon at the right to add a calculated field
      •   
    2.  
    3. Provide the inputs required      
           
      • User-added image
      •   
    4.  
    5. Script (In Expression field):      
           
      • (Substring(ToStr((([Total Time Spent]/60)/60)/24),0,(CharIndex('.',ToStr((([Total Time Spent]/60)/60)/24)))))+':'+Substring(ToStr((((([Total Time Spent]/60)/60)/24)-ToInt((Substring(ToStr((([Total Time Spent]/60)/60)/24),0,(CharIndex('.',ToStr((([Total Time Spent]/60)/60)/24)))))))*24),0,CharIndex('.',ToStr((((([Total Time Spent]/60)/60)/24)-ToInt((Substring(ToStr((([Total Time Spent]/60)/60)/24),0,(CharIndex('.',ToStr((([Total Time Spent]/60)/60)/24)))))))*24)))+':'+ToStr(Round((((((([Total Time Spent]/60)/60)/24)-ToInt((Substring(ToStr((([Total Time Spent]/60)/60)/24),0,(CharIndex('.',ToStr((([Total Time Spent]/60)/60)/24)))))))*24)-ToInt(Substring(ToStr((((([Total Time Spent]/60)/60)/24)-ToInt((Substring(ToStr((([Total Time Spent]/60)/60)/24),0,(CharIndex('.',ToStr((([Total Time Spent]/60)/60)/24)))))))*24),0,CharIndex('.',ToStr((((([Total Time Spent]/60)/60)/24)-ToInt((Substring(ToStr((([Total Time Spent]/60)/60)/24),0,(CharIndex('.',ToStr((([Total Time Spent]/60)/60)/24)))))))*24)))))*60))
      •   
    6.  
    7. Add the field in the Report canvas      
           
      • User-added image 
      •   
    8.  
    9. Save and Run the report

     


    Article Number:

    000181896


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles