How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours)

[steven_me]

Guys i need help with a function in Excel.

I need to substract the time difference to identify the time taken t
complete a task, however the following needs to be included

- List of Holidays
- During Business Hours Only

Hence if
A1 = Activity Start Date
B2 = Activity End Date
X1 = Business Hours Start Time
X2 = Business Hours End Time
R1:13 = List of Holidays

How would i get this done ?

I dont want to use the work days formula as it excludes Weekends.

Please help

 

[steven_me]

Guys i need help with a function in Excel.

I need to substract the time difference to identify the time taken t
complete a task, however the following needs to be included

- List of Holidays
- During Business Hours Only

Hence if
A1 = Activity Start Date
B2 = Activity End Date
X1 = Business Hours Start Time
X2 = Business Hours End Time
R1:13 = List of Holidays

How would i get this done ?

I dont want to use the work days formula as it excludes Weekends.

Please help !

Any luck guys ? Is this possible or aint

 

[Spencer101]

Guys i need help with a function in Excel.

I need to substract the time difference to identify the time taken t
complete a task, however the following needs to be included

- List of Holidays
- During Business Hours Only

Hence if
A1 = Activity Start Date
B2 = Activity End Date
X1 = Business Hours Start Time
X2 = Business Hours End Time
R1:13 = List of Holidays

How would i get this done ?

I dont want to use the work days formula as it excludes Weekends.

Please help !

If you can post an example workbook you'll get a reply much sooner...