Suppose we need to round up the following data (in minutes) in a SharePoint Column to later hour: -
Time
10
30
60
90
140
Here's how one can go about it.Add a new calculated field and add the following Excel function - ROUNDUP(value, number of digits). Our formula would be - ROUNDUP([Time]/60,0). This would round up the minutes to nearest later hour. Hence result would be: -
Time
10 1
30 1
60 1
90 2
140 3
Tuesday, March 9, 2010
Rounding up minutes to nearest later hour
Subscribe to:
Post Comments (Atom)
1 comments:
Your blog was very useful for us we are a newly emerging share point development company, Thank you and keep up the good work.
Post a Comment