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

Top