Round Off Number to the Highest Integer in Saved Search

 

User is using the Time Tracking feature. User created a custom field that automatically converts the time to numeric value (field name: Duration). The Duration field needs to be rounded to the highest integer number so user does not have to calculate for the minutes in excess.

For Example: If an employee worked for 4.20 hours in a day, this is to be rounded to 5.0, instead of the normal 4.20 = 4.

To accomplish this, perform the following steps:

     1. Navigate to Reports > Saved Searches > All Saved Searches > New.

     2. Select Time.

     3. In the Results tab > Columns subtab, set the following:

Fields	Summary Type	Formula
Start Time
End Time
Duration
Formula (Numeric)		CEIL({customfieldxx})

Note: {customfieldxx} is the ID of the custom field.

4. Click Save & Run.