I have two Columns namely Received Date & Time and Updated Date & Time. I
want to calculate the number of hours taken in between the received and
updated.

The problem i have is
1. We need to consider only the working hours. That is from 09:30 AM to
07:00 PM of all working days.

2. And i need to eliminate sundays and Holidays(Which is not fixed, it may
be 3 to 4 days in a Month, if i can specify the exact date of a holiday that
need not to be considered for calculation)

Kindly post a remedy for my query and help me.

Thanks in advance

Karan.

Dear all,

I have customed both the Columns as under in Excel 2000.

dd.MM.yyyy hh:mm:ss AM/PM

for example the field looks like = 24.04.2007 12:12:00 PM

Thanks

Karan.

"Karan" wrote:

I have two Columns namely Received Date & Time and Updated Date & Time. I
want to calculate the number of hours taken in between the received and
updated.

The problem i have is
1. We need to consider only the working hours. That is from 09:30 AM to
07:00 PM of all working days.

2. And i need to eliminate sundays and Holidays(Which is not fixed, it may
be 3 to 4 days in a Month, if i can specify the exact date of a holiday that
need not to be considered for calculation)

Kindly post a remedy for my query and help me.

Thanks in advance

Karan.

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.