Hello,

I have a column to track TIME spent in minutes (integer).  I want a calculated column which will round UP to the nearest interval of 5.  i.e. 2 mins becomes 5, 17 mins becomes 20, etc.

Is this possible?

Here are my 2 cents:

Do you have a min and max limit on number of minutes that can be entered?

If so, you can write a bunch of formulas using rules in Infopath designer oh and you should use a normal number column, not a calculated one

If([Column1]>5 AND [Column1]<10) -> Set value to 10 and so on. 

Thanks for the suggestion, however in this case I can not use Infopath.  It is a VERY simple list with only a couple columns. 

Hi,

As I understand, you want the calculated column to round up to nearest interval of 5 in SharePoint 2013.

You could add the formula below in the calculated column. You could change the num column to your time column.  You should judge the value of the time column between which number intervals, then you could set the value according the number interval. And you could add more if condition in the calculated column according your requirement. And please note: do not miss the closing bracket in the end.

 =IF([num]<=5, 5, IF([num]<=10,10,IF([num]<=15,15,IF([num]<=20,20,25))))

If you want to know more information about multiple if conditions in the calculated column, you could refer to the article below.

The article below is about Maximum number of IF statements in a Calculated Column.

http://blog.pathtosharepoint.com/2010/04/12/maximum-number-of-if-statements-in-a-calculated-column/

Best regards,

Sara Fan

Thank you Sara.  Not very elegant, nor entirely practical I suppose.  I think I will simply ask my users to round it when entering the data:-)

OK, apparently this is more simple than I thought.  I used the CEILING function from Excel, and it works fine in SP.

=CEILING([Time Spent],5)

• Marked as answer by PrairieSailor 17 hours 50 minutes ago