Tat calculation only for business days

**Premmadaan** · 12-04-2008, 09:42 AM

This site is Great..

Hi all,

Guys i am not able to calculate TAT(Turn around Time) between two dates without taking Off days. Plz help me on this.. File is attatched as per example..

**NBVC** · 12-04-2008, 09:46 AM

If you have the Analysis Toolpak addin installed (Tools|Options|Addins)

Then use: =Networkdays(A2,B2) copied down

**sweep** · 12-04-2008, 09:48 AM

Hi,

Take a look at the =NETWORKDAYS() function, available by installing the Analysis ToolPak add-in.

**Premmadaan** · 12-04-2008, 10:03 AM

Is there any other method for this ? bcz this function is not working.

Thnks for reply

:

Originally Posted by NBVC

If you have the Analysis Toolpak addin installed (Tools|Options|Addins)

Then use: =Networkdays(A2,B2) copied down

**NBVC** · 12-04-2008, 10:06 AM

Try installing the Analysis Toolpak... through Tools|Options|Addins.

It should install.. it may ask for your installation CD.

**NBVC** · 12-04-2008, 10:13 AM

or try:

Please Login or Register  to view this content.

**Premmadaan** · 12-08-2008, 05:19 AM

Thanks a lot. This site is unbelievable. Thanks again..

Originally Posted by NBVC

or try:

Please Login or Register  to view this content.

**Imranshaikh** · 09-29-2010, 04:00 PM

Activity Start Time End Time Hours
465085 9/17/2010 4:34 9/22/2010 17:17 ????

I want to calculate TAT in Hours, excluding saturday and sunday.

**marc5354** · 09-29-2010, 04:11 PM

Hello Imran Shaikh

Please start a new thread for your query. Rule # 2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

Marc