Date/Time Difference Excluding Weekends & Holidays

P

Paula D

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!
 
T

Teethless mama

A1: start date/time
B1: End date/time

=(NETWORKDAYS(A1,A2,holidays)-1+MOD(A2,1)-MOD(A1,1))*24

Format cell as General
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2
Calculation completion date/time 6
How to calculate difference between two date & time along with working hours and days 2
Calculate elapsed time excluding specific timeframe 10
Calculate End Date (excluding weekends and holidays) 6
WORK HOURS DIFFERENCE BETWEEN TWO DATES 12
Calculating Turn Around Times excluding Sunday 1
Calculate the total overlapping time of multiple tasks, excluding non-working times 1

Top