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
Showing posts with label document library. Show all posts
Showing posts with label document library. Show all posts
Tuesday, March 9, 2010
Rounding up minutes to nearest later hour
Labels: document library, excel, formulaWednesday, June 3, 2009
Error while moving documents across site collections, sites - cannot read from source file or disk
Labels: document library, error, sharepointUsing windows explorer one cannot drag n drop (cut-paste) documents across site collections.
If you try to cut-paste (drag-drop) documents across site collections or across sites in same site collection, you would get the following error: -
"cannot read from source file or disk"
WORKAROUND
1) Open the source and destination libraries as network places. (using add a new network place).
2) Browse to the document libraries in question.
3) Drag-drop the files.
4) There’ll be no error.
Things to check at client’s end: -
1) Check if Webclient service is running and is set to auto start in services.msc. Stop and restart it.
Subscribe to:
Posts (Atom)