Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
Hi All,
Thanks
we have the following sheet
now we want the delay time in column Sheet1!C5:C11 but want to exclude the holyday, sunday and time delay will be count as per office hours
Sunday, Holiday and Office Hours are
help pls
Thanks
we have the following sheet
One | |||
Two | |||
Three | |||
Plan Date | Actual Date | Time Delay | Status |
10/28/2020 18:00:00 | 10/27/2020 10:10:29 | OK | |
10/28/2020 18:00:00 | 10/27/2020 10:10:29 | OK | |
10/28/2020 18:00:00 | 10/29/2020 10:10:29 | OK | |
10/16/2020 18:00:00 | 10/15/2020 13:55:28 | OK | |
10/16/2020 18:00:00 | 10/15/2020 17:13:35 | OK | |
10/20/2020 18:00:00 | 10/19/2020 16:09:26 | OK | |
10/20/2020 18:00:00 | 10/21/2020 17:17:39 | OK | |
now we want the delay time in column Sheet1!C5:C11 but want to exclude the holyday, sunday and time delay will be count as per office hours
Sunday, Holiday and Office Hours are
Sunday | Holiday | Office Timing |
10-06-2020 | 08-10-2020 | 11:00 |
13-10-2020 | 22-10-2020 | 18:00 |
20-10-2020 | ||
27-10-2020 | ||
help pls