How would you calculate the hours?Example:05:00 15:00 = 10 hours07:00 12:00 = 5 hours12:15 to 14:30 = 2 hours 15 minutes.
View Complete Post
I have tried searching all over the web for this logic. Got many but half of them did not match what i was looking for and half were malfunctioning.
I want to calculate business working hours between 2 datetime, where in I should be able to set the working hours as well as weekends and holidays should not be calculated.
Please help me guys... It will be a great help...
Working days - Mon-Fri and Working hours - 9 Am to 5 Pm
Thur, 14-Oct-10 11.30 Am Thur, 14-Oct-10 5.00 Am 5.30
Fri, 15-Oct-10 11.30 Am Mon, 18-Oct-10 5.00 Am 13.30
Mon, 18-Oct-10 11.30 Am Mon, 18-Oct-10 6.00 Am 5.30
I am trying to calculate the number of hours between 2 date/time fields in a list form.
If I do this on a list view level with a calculated column, the column is not available for column summaries. Therefor I intend to use a regular number column and calculate the hours in an InfoPath form. Obviously the formula for calculated fields in list
columns will not work in InfoPath.
Addition: I tried DateField1-DateField2, but the result is NaN...
On occasion the incrmental crawls; which usually take under 1 minute take hours to run.
The crawl logs show a successful crawl message and the nothing til it completes, not a single log entry.
It will eventually finish and the next incrmemental will run just fine.
No errors or anything to speak of.
Index has 800K items
how do I go about generating formulas for something like this.
I have a field( choice ) that has three choices (Low, Medium and High ). If I choose Low, I need to add 5 days to the current date( excluding weekends ) and place it in the Target date field, the same goes for Medium = 3 days( exclude weekends) , High =
1 day, exclude weekends.
Is there anyway where we can use KPI list to attach to a SharePoint list and indicates which item was clicked the most ? Or any other way to find out the best 5 links based on how many times they were accessed by a user?
Thanks in advance
for Business needs i am planning to increase the session timeout to 2 hours(120 min) in one application, i am using sql server session state. if i increase to 2 hours of session time out, how it will effect the performance of application and web server.
Could any one help me on this.