Guys i need help with a similar function in Excel.
I need to substract the time difference to identify the time taken to 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 !
Quote:
Originally Posted by Paula D[_2_]
Thanks so much Mama - I'll give it a whirl. I appreciate the help!
Paula
"Teethless mama" wrote:
A1: start date/time
B1: End date/time
=(NETWORKDAYS(A1,A2,holidays)-1+MOD(A2,1)-MOD(A1,1))*24
Format cell as General
"Paula D" wrote:
I'm running a report to show the turn-around times for a task, but want to
exclude weekends and holidays. For instance if an employee began working on
a task on Friday, March 9th 2007 4:00 pm (column a) and completed it on
Tuesday, March 13th, 2007 4:00 pm (column b), I want to calculate in column c
what the true turn-around time (date/time difference) was, excluding the
Saturday and Sunday in between since these weren't work days and shouldn't
count against that employee. The turnaround time should calculate to 48
hours but because the weekend is in there, it shows as 96 hours. Any ideas?
Thank you!
|