Dear all,

I need to calculated the TAT (Turn Around Time):

We receive particular task, which is needed to be completed in 06 working
hours. otherwise we need to give reasons for the delay. To find out
manually it takes lot of time for each task. That is the reasons i need this
formula for calculating the hours in TAT.

For Example:
1. A task is given on 21.04.2007 03:30:00 PM (Which is a Working day, Friday)
2. Saturday, 22.04.2007 is a holiday.
3. Sunday, 23.04.2007 is a weekly holiday.
4. We have replied with the details about the task on 24.04.2007 11:00:00 AM
5. 03 Hours 30 Minutes are from Friday
6. 01 Hour 30 Minutes are from Monday
7. The TAT is 05 Hours.
8. Note that Saturday(it may be any week day) and Sunday (Weekend) is
eliminated.

I need formula for this calculations.

I use Excel 2000

Date and Time is customized as dd.MM.yyyy hh:mm:ss AM/PM

It will be great help if some body can help me on the above. thanks in
advance.

Thanks and have a great day !!

Karan.