How to Roundup a column “Elapsed hours” into blocks of 5?

Report on elapsed hours

Applies to: SharePoint On-premisis

Requirement: Round up a column "Elapsed hours" into blocks of 5 and build a report based on it (Eg: 177 to 180, 53 to 55).

– Create a calculated column with formula: =CEILING([Elapsed Hours],5) to round up value of the column to 5 and use this column in the reports.

– Create a report like shown below

Sample report preview:

 For more sample reports refer

Leave a Reply