Dear all,

With reference to my previous mails, more information is given below:

We receive particular task, which is needed to be completed in 24 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

Hope to get an answer for you'll.

Thanks and have a great day !!

Karan.