Calculate A Due Time (hrs) Excluding Non-work Hours, Holidays, And sunday

0

Hi,

Please help me fro getting due date excluding holiday and sunday, i need on urgent basis as i spent lots of days to make the formula.

Start Date/Time Solve within hours Workday Start Workday End Holidays 24-10-2016 12:22 6 09:30:00 18:30:00 27-Oct-16 27-10-2016 08:57         28-10-2016 11:53         28-10-2016 17:18         28-10-2016 19:39         28-10-2016 21:52         28-10-2016 23:53         29-10-2016 02:11         29-10-2016 09:23         29-10-2016 09:34        

Thanks

Neeraj Kaushik

Answer
Discuss

Answers

0
Selected Answer

Checkout our Networkdays() tutorial. This tutorial also has a sample file that you can download to help you get started with the formula, but here is the basic syntax:

=NETWORKDAYS(start_date, end_date, [holidays])
Where the holidays argument can be a range that contains a list of dates.

You can use the NETWORKDAYS() function along with the holidays argument.

In your case, since saturday should count as a "holiday" for you, just get a list of dates for the saturdays and include that in the list of holidays. There might be a better way to do this but that's just a quick thought.

Discuss
0

 Hi,.

See the attahced file , answar should be End Date/Time-29-10-2016  02:18:32 PM but it is coming 31-10-2016  02:18:32 PM, please help

Regards

Neeraj

8826618371

Discuss

Discussion

Im not seeing any of that in the file attached to your question. If you have more information to add, update your original question.
don (rep: 1482) Jan 19, '17 at 3:25 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login