No announcements

### Calculating working hours without weekends

to calculate the time elapsed between two dates, considering working hours time frame and subtracting weekends ? Thank you very ...
| 2 Replies | 462 Views | Created by Rui Casais Alves - Wednesday, July 15, 2020 12:38 AM | Last reply by Imke Feldmann - Tuesday, August 25, 2020 11:28 AM

### Datedif calculating difference excluding weekends

Im having a problem with the formula for calculating days of the week excluding weekends. Ive created a holiday calendar with an ...
| 7 Replies | 13694 Views | Created by nick9one1 - Monday, January 24, 2011 2:19 PM | Last reply by Tom Molskow - Wednesday, January 26, 2011 2:45 AM

### How to our own calendar in Infopath form?

Hi, According to your post, my understanding is that you wanted to assign a task with due date of 7 working days excluding weekends and ...
| 1 Replies | 980 Views | Created by SamDany - Thursday, July 17, 2014 9:39 AM | Last reply by Lindali - Friday, July 18, 2014 3:30 AM

### Formula for calculating date variances avoiding weekends

Have you looked at the built-in Finish Variance field?  it calculates the difference (in working days) between the finish and baseline finish fields.
| 2 Replies | 829 Views | Created by nevkimbers74 - Thursday, November 26, 2015 12:22 PM | Last reply by Julie Sheets - Sunday, November 29, 2015 9:47 PM

### Add hours to a date excluding weekends.

Hi , Check the below example for adding hours to a date but excluding weekends DECLARE @StartDate ...
| 6 Replies | 2907 Views | Created by rajiv460 - Thursday, September 25, 2014 5:21 AM | Last reply by Patrick Hurst - Monday, September 29, 2014 3:00 PM

### Calculating Working hours using data in SharePoint List 2010

Hi, According to your post, my understanding is that you wanted to Calculating Working hours using data in SharePoint List 2010. You ...
| 1 Replies | 2395 Views | Created by Neo-Sharepoint Intern - Wednesday, April 2, 2014 10:11 AM | Last reply by Lindali - Friday, April 4, 2014 4:53 AM

### Calculating total number of working hours per year

, calculate total hours spent by the resource and divide it on total number of working hours available for the resource with respect to it's Calendar. How ...
| 7 Replies | 10938 Views | Created by Andrey Kazak - Wednesday, February 22, 2012 7:46 AM | Last reply by Jan De Messemaeker - Project MVP - Monday, February 27, 2012 11:35 AM

### Query for Calculating OT Hours

4:45 AM and left around 14:01 then system calculating OT hours as 15 Min.. I need a report OT hours/ Min need to calculate after shift end for ex., 14:01 ...
| 15 Replies | 702 Views | Created by Vino_tnj - Monday, July 30, 2018 12:27 PM | Last reply by Rachel_Wang - Thursday, August 2, 2018 6:46 AM

### calculating working days between 2 days excluding bank holidays and weekends

Hi, I am trying to create a holiday system in sharepoint and need the formula in a field to calculate the amount of days taken excluding any weekends or ...
| 1 Replies | 1530 Views | Created by Kirstie_11 - Friday, November 15, 2013 9:48 AM | Last reply by romeo donca - Friday, November 15, 2013 10:57 AM

### Calculating hours elapsed between two dates but excluding non-work hrs (weekends & hrs between 6 pm & 8 am)

Hi Folks I want to calculate the hours elapsed between two dates, but also need to exclude non work hours (weekends, hrs between 6 pm and 8 am, and ...
| 1 Replies | 6050 Views | Created by Steve_Fox - Monday, May 31, 2010 9:57 AM | Last reply by Manikandan S - Monday, May 31, 2010 10:12 AM

### Exclude weekends when calculating a Task Due Date

same topic, if you don't like or understand the answer you already got. If you want to calculate the due date without weekends in it, just use the code you got. ...
| 6 Replies | 9410 Views | Created by gah80 - Tuesday, May 24, 2011 4:41 PM | Last reply by gah80 - Wednesday, May 25, 2011 12:32 PM

### Calculating date difference in business hours

Hi I was faced with the same problem and found that the following SQL line worked for me - I have a ticket (logged) date and a resolution date for each ticket and our ...
| 7 Replies | 11562 Views | Created by Erik Monchen - Wednesday, July 28, 2010 12:49 PM | Last reply by _slabach - Thursday, October 4, 2018 3:49 PM

### Calculating SLA hours between 2 dates

I created VB function to calculate hours between 2 dates excluding weekends. Now I would have to consider "operating hours" - Operating hours 1: ...
| 3 Replies | 5567 Views | Created by Ulka - Monday, October 26, 2009 8:13 PM | Last reply by Ulka - Tuesday, November 10, 2009 5:25 PM

### Bussiness Hours calculation between two dates excluding holidays and weekends

hai , can anyone help me to find the bussiness hours between two days excluding the holidays and weekends. and also if the ...
| 3 Replies | 10200 Views | Created by D S R Pavan Kumar - Monday, June 4, 2012 8:22 AM | Last reply by Elvis Long - Thursday, June 14, 2012 1:42 AM

### Consider Bank Holiday while calculating datediff (hours)

Hi experts, Pls help me with this query of mine. I am calculating datediff in hours using the following ...
| 4 Replies | 4062 Views | Created by Sweta Dutta - Monday, August 24, 2009 11:09 AM | Last reply by Sweta Dutta - Monday, August 24, 2009 11:38 AM

### Working hours

;. Connected them to each other. The calendar showed the working hours of the company. But when creating the incident, the &quot
| 2 Replies | 621 Views | Created by Ilya Campfire - Tuesday, March 14, 2017 2:21 PM | Last reply by Ilya Campfire - Friday, March 17, 2017 11:50 AM

### Calculating employee hours on multiple projects

of hours per week that each staff member is working on each project. The hours assigned to each project will be subtracted from the total hours per week of each ...
| 2 Replies | 4446 Views | Created by THTolleson - Thursday, July 23, 2009 6:38 PM | Last reply by THTolleson - Wednesday, July 29, 2009 5:46 PM

### calculate working days excluding weekends

Hi, Iam trying to calculate the number of working days between two dates. Iam getting the uouput as only 1 02 r working ...
| 8 Replies | 809 Views | Created by CSharp Neophyte - Sunday, June 7, 2015 12:52 PM | Last reply by Patrick Hurst - Monday, June 8, 2015 3:12 PM